{"text_format":"1","workbook":"xlsx","n_sheets":12,"sheets":["Revision History","Overview","Instructions","System Information","Component Summary Sheet","Risk Rating","Comp 1","Comp 2","Comp 3","Comp 4","Comp 5","Category Guidance"],"not_rendered":{"charts":6,"images":0,"macros":1,"external_links":0,"defined_names":17,"comments":5,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Revision History","index":0,"n_rows":11,"n_cols":4,"rows_kept":11,"cut":false,"hidden":false,"merged":[[2,2,2,3]]}
[]
["Revision","Date","POC","Detailed Description of Change"]
[0,"2019-07-01","Initial Supplier Risk Mapping construct leveraged from Lockheed-Martin ADP, Palmdale, CA"]
[1,"2019-11-01","Wylie Consulting","Base Document - Supplied by Gov. Contractor"]
[2,"2020-03-01","Wylie Consulting","Simplification revisions - added instructions"]
[3,"2020-03-15","Wylie Consulting","Improved usability and simplified interface"]
[4,"2020-04-15","Wylie Consulting","Added separate weighting worksheet, aligned risk management terminology with DOD Risk Management Guide\nhttps://www.acq.osd.mil/damir/documents/DAES_2006_RISK_GUIDE.pdf"]
[5,"2020-05-05","Wylie/Cowles","Significant modification to the Risk Management Scoring Method\nRemoved Question Weighting as a method for scoring Impact/Likelihood\nAdded Likelihood and Consequence scoring to each Component Page\nReplaced Guidelines with Overview and updated Instructions page"]
[6,"2020-06-27","Wylie/Cowles","Minor clean-up and improvement in readability."]
[7,"2020-07-15","Wylie/Cowles","Added Error Protection, Improved Conditional Formatting"]
[8,"2020-08-22","Wylie","Cleaned up printing hard copy of all pages (improved Header/Footer)"]

{"sheet":"Overview","index":1,"n_rows":15,"n_cols":2,"rows_kept":15,"cut":false,"hidden":false,"merged":[]}
["Item","Overview"]
[1,"Background and Introduction: Programs in the development and acquisition process need to assess manufacturing readiness. Multiple components, sub-systems, and/or suppliers may be involved.  Technology and manufacturing readiness may vary significantly amongst these components and suppliers, posing different levels of risk likelihood and severity to the program. This spreadsheet was developed as a tool for initial assessment of risk posed by individual components and suppliers. This assessment can then be used to allocate program resources effectively, to conduct appropriate levels of component/supplier reviews, including MRA self-assessments and full MRA assessments where indicated. Results can then be used to identify and reduce program risks, and accelerate manufacturing maturation and readiness. This tool is intended to supplement the well-established MRA/MRL process; it is not a substitute for that process."]
[2,"General Description: This spreadsheet was developed for use in advance of a system-level or product-level MRA, specifically for initial risk assessment posed by individual components, sub-components, and associated suppliers. The concept was originally developed as a \"Supplier Heat Map\" tool by Lockheed-Martin ADP, in Palmdale, CA. Lessons learned since initial application have resulted in significant improvements, more direct ties to key aspects of the DOD MRA/MRL process, and broader range of applicability.  The users - meaning representatives of the subject program - identify the components (and/or sub-components) and associated suppliers comprising the program. Key OEM or system-level processes such as product integration or assembly should be considered as well.  Each component/supplier has a specific tab in the workbook. Each component/supplier is individually assessed - by simple \"yes-no\" responses to 9 key risk questions representing the 9 MRA threads.  For any \"yes\" response to the risk questions, the representatives generate a simple statement of risk, and record their estimate of \"Likelihood and Consequence\" in a 5x5 risk table format. The spreadsheet then sums the risks, calculates a weighted average \"Likelihood - Consequence\" value for the component/supplier, and displays the results in the familiar 5x5 risk matrix format. The weighted average values for all components/suppliers are displayed in a consolidated 5x5 risk matrix plot on the \"Risk Rating\" tab. Results are also presented in table format on the \"Component Summary Sheet\" tab. Red-Yellow-Green color coding, consistent with the DOD Risk Management Guide, provides visual assessment of the various components/suppliers. It is expected that results from this tool will be useful for communication and allocation of program resources for detailed assessments, including MRAs, development of MMPs or other risk management decisions."]
[3,"9 Key Questions on Component/Supplier Tabs: These question are taken directly from the DOD MRL Deskbook (pp 32) - http://www.dodmrl.com/MRL_Deskbook_2018.pdf. The questions are intended to provoke simple assessment on a yes-no basis related to each of the 9 threads in the MRA /MRL process. For \"yes\" responses, the participants should generate a simple (~10 word) risk statement."]
[4,"Likelihood-Consequence Assessment on Component/Supplier Tabs: For \"yes\" responses, participants estimate the likelihood and consequence in the NASA and DOD 5x5 risk matrix, in table format. Use of this format and the category guidelines were taken directly from the Risk Management Guide for DOD Acquisition - Sixth Edition (Version 1.0). Note that some or many of the 9 questions may have a \"no\" response for the specific component/supplier being addressed."]
[5,"Weighted Average Likelihood-Consequence Assessment on Component/Supplier Tabs: Since there may be several likelihood - consequence responses, a weighted average value is calculated for each component/supplier. This value is then used for comparison with other component/supplier risk assessment results.  Weighting is based on the individual Likelihood or Consequence score assigned;(i.e.: a score of 5 is weighted higher than a score of 4 or 3 etc.)"]
[6,"Red/Yellow/Green areas on the 'Risk Rating' worksheet are somewhat subjective:  They are consistent with the Risk Management Guide for DOD Acquisition, and generally with the NASA 5x5 Risk Matrix.  Those references, however, provide for \"categorical assessments\" (e.g.: box 3-4, or 4-5). This spreadsheet has continuous numerical scales for both Likelihood and Consequence axes, so the R-Y-G boundaries are shown as straight lines. Even though the areas are distinct, engineering, scientific, and manufacturing intelligence must be used to assess whether the component/supplier risk is High, Med, or Low, and managed as such."]
[7,"Components/Suppliers in \"Red\" Area: Components/Suppliers Falling within the Red area on the Risk Matrix are designated as High Risk and it is recommended that they receive a full MRA."]
[8,"Components/Suppliers in \"Yellow\" Area: Components/Suppliers falling within the Yellow area on the Risk Matrix are designated as Moderate Risk. It is recommended that they conduct an MRA Self Assessment, with an Option for a full MRA to be determined by the MRA team."]
[9,"Components/Suppliers in \"Green\" Area: Components/Suppliers Falling within the Green area on the Risk Matrix are designated as Low Risk. It is recommended that these suppliers not be required to conduct an MRA, but periodic review of their status as \"Green\" be performed."]
[null,"Other Notes:"]
[10,"Risk Matrix risk ratings are initial recommendations based upon In-House and External SME knowledge early in the program and should be treated as recommendations. A supplier may be selected for any level of MRA regardless of Risk Matrix rating if it is deemed necessary by Program Management. "]
[11,"Likelihood (or probability of occurrence) and Consequence (or severity of impact) are based upon collective input from the Program's Supplier or Component Technical Leads and approved by Program Manager."]
[12,"Impact Weightings on the \"System Information\" worksheet may be established by Program Management early in the program and held constant for all components/suppliers. These affect only the Impact Scores derived from the Likelihood-Consequence assessments. They are used only for informational purposes in comparing component/suppliers. In general, it is recommended that the default weighting factor for all 9 key questions be equal."]
[null,"Wylie/Cowles 4/29/2020"]

{"sheet":"Instructions","index":2,"n_rows":14,"n_cols":2,"rows_kept":14,"cut":false,"hidden":false,"merged":[]}
["Item","Instructions for using this Spreadsheet"]
[1,"First time users: please read the introductory material found on the Overview tab."]
[2,"Prework: designated participants should identify all significant components, sub-systems, associated suppliers, and key OEM processes involved in the program.  Key MRL target gates, requirements, and schedule should be known to participants. Appropriate participants representing design or structures requirements, materials, quality, manufacturing, supply chain management, and  program management should be identified and involved as appropriate."]
[3,"System Information tab: Company name, System name or identifier, revision number and revision date should be entered in appropriate boxes. An appropriate DOD or other Distribution Statement may be entered. This will appear on other tabs. Default entry is \"No Distribution Statement Determined.\" The 9 key manufacturing questions should be reviewed in the context of the subject program. For most programs, it is expected that when the questions are assessed for \"Likelihood\" and \"Consequence\" of risks associated with each question, that the relative importance to the program will be considered. In this case (recommended), equal \"System Weighting Factors\" (11.1) for each of the 9 key questions should be assigned. In event non-equal weighting is considered necessary, please comment on the rational for the weighting choices.  The total of the weighting factors must be 100.  These weightings will be program specific and the same for all component/suppliers within the program to ensure consistency. These weighting factors are used only to determine the total \"Weighted Impact Score\" for each component. They will not affect the Likelihood-Consequence assessments, nor position on the 5x5 consolidated risk matrix."]
[4,"System Information tab: Review the number of months inserted in the \"System Critical Schedule Drivers\" table. These are used in your assessment of \"consequence\" categories when schedule may be impacted, so need to be specific to your program."]
[5,"Component/Supplier tabs and the Component Summary Sheet: The template has many generic component worksheets.  You may create more worksheets if you need to by right-clicking a similar component tab and selecting Move or Copy.  Name the TAB for your components the EXACT same as the name in Column A of the \"Component Summary Sheet\".  Exact spelling is needed to ensure formulas work correctly that pull data from the various component worksheets. You should list on this worksheet all of the components/suppliers to be assessed, and ensure each has an individual tab."]
[6,"Component/Supplier tabs: Review one of the blank tabs provided to become familiar with it. Title and reviewer information can be entered along the top of the sheet where shown.  The lower right side of each sheet contains reference material for your use when assessing Likelihood and Consequence - for that component/supplier.  What you will fill in are yes-no responses to the 9 key manufacturing questions - in the context of your program or system, and for the subject component/supplier. Hover over cells A5 - A13 and the questions will appear for each category. For \"y\" responses, the cells to the right of that response will color light yellow - indicating you should enter a brief explanation of why response was \"y.\" Example for Materials question might be... \"New material under development.\"  The associated risk statement in the next cell might be...\"Development schedule slips,\" or \"Material quality issues may impact system performance\". Be brief - it is just a note to use when assessing Likelihood and Consequence."]
[7,"Component/Supplier tabs - Determining the Likelihood-Consequence values:  For each key question answered \"y\" - and their associated risks, you must enter a \"Likelihood\" and \"Consequence\" assessment - each with a number from 1 to 5. The category guidelines for these are on the right side of the sheet. The spreadsheet will then calculate an \"Impact Score\" - which is simply the product of Likelihood and Consequence. Note - you only fill in L-C values for the key questions where you responded \"y.\"  The spreadsheet will ignore the blank responses. For some components/suppliers, you may have few if any yes responses. The spreadsheet will fill out the remaining areas, including a weighted average Likelihood-Consequence result, a weighted Impact Score, and the Likelihood-Consequence plot for this supplier/component."]
[8,"Component/Supplier tabs - Weighted Likelihood-Consequence values: This is a critical result. On the component/supplier tab, it is shown in the plot along with whatever other L-C results for key risks were determined for this component/supplier. It is also displayed for comparison with all other component/supplier results on the \"Risk Rating\" tab, and in tabular form on the Component Summary Sheet."]
[9,"Component/Supplier tabs - Actions and Comments table: an area is provided at the bottom of each component/supplier tab where specific actions, dates and comments can be recorded. Revision date and history should be recorded here for changes to each component tab."]
[10,"Component Summary Sheet: this tab summarizes all results in table format. It is populated automatically from the individual Component/Supplier tabs with the exception of \"Component Name\", \"Supplier Status\", and \"Component Description\" which must be entered on this sheet."]
[11,"Risk Rating tab: this tab summarizes all weighted average Likelihood-Consequence results in risk rating format. It is also populated automatically from the individual Component/Supplier tabs. Adjust the view of the \"Risk Rating\" worksheet to maximize readability and clarity of the message.  This will be the most management reviewed worksheet from this workbook."]
[]
["Fmt","Correcting Chart Data Labels in Excel: After entering your L/C scores,  the data labels may appear as empty. If so, they must be reset in Excel.  Follow this procedure to make your data labels appear properly.\n1. Right Click on the data label box\n2. Select \"Format Data Label\"\n3. In the right hand drop down box select the far right \"Label Options\" Category\n4. Uncheck the box \"Value From Cells\"\n5. Re-Check the box \"Value From Cells\"\n6. Click \"Reset Label Text\"\n7. Close the EDIT drop down box"]

{"sheet":"System Information","index":3,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[25,0,25,1],[26,2,26,14],[27,2,27,14],[21,1,21,14],[16,1,16,14],[17,1,17,14],[18,1,18,14],[19,1,19,14],[20,1,20,14],[38,0,38,2],[0,0,1,14],[39,3,42,3],[36,2,36,14],[34,2,34,14],[35,2,35,14],[14,0,15,14],[28,2,28,14],[29,2,29,14],[30,2,30,14],[31,2,31,14],[32,2,32,14],[33,2,33,14],[22,1,22,14],[23,1,23,14],[24,1,24,14],[3,1,3,5],[4,1,4,5],[5,1,5,5],[6,1,6,5],[9,0,11,14],[3,7,4,10]]}
["Company and System Information Sheet"]
[]
[]
["Company Name:","Trial Company",null,null,null,null,null,"Entry Fields : This Color"]
["System Name:","Trial System"]
["Revision #:","Rev 1"]
["Revision Date:","2020-07-15"]
[]
["Distribution Statement"]
["DISTRIBUTION STATEMENT: No Distribution Statement Determined. "]
[]
[]
[]
[]
["System Level Weighting Factors for Key Manufacturing Questions"]
[]
["Materials","Are there materials which have not been demonstrated in similar products or manufacturing processes? "]
["Cost","Is this item a driver that significantly impacts lifecycle cost (development, unit, or operations and support costs)? Is the technology new with high cost uncertainty?"]
["Design","Is the item design novel or does it contain nonstandard dimensions or tolerances or arrangements? "]
["MFG. Process","Will the item require the use of manufacturing technology, processes, inspection, or capabilities that are unproven in the current environment? "]
["Quality","Does the item have historical/anticipated yield or quality issues? "]
["Schedule","Does this item have lead time issues or does it significantly impact schedule? "]
["Facilities","Does this item require a new manufacturing facility or scale up of existing facilities (i.e., new capability or capacity)? "]
["Supply Chain MGMT.","Does the item have anticipated or historical sub-tier supplier problems (e.g., cost, quality, delivery)? "]
["Industrial Base","Does the item have an industrial base footprint with critical shortfalls or is this a critical item manufactured by a sole or foreign source?"]
["REF: page 32 DoD MRL Deskbook 2018"]
["Category","Weighting Factor","Rationale for Deciding Weighting Factor"]
["Materials",11.1]
["Cost",11.2]
["Design",11.1]
["MFG. Process",11.1]
["Quality",11.1]
["Schedule",11.1]
["Facilities",11.1]
["Supply Chain MGMT.",11.1]
["Industrial Base",11.1]
["Total (must = 100)",{"$f":"SUM(B28:B36)","v":99.999999999999986}]
[]
["System Critical Schedule Drivers\nfor Consequence Estimation"]
["Minimum Minor schedule slip Allowable: Less than",6,"Months","Enter  values for the THIS  program"]
["Minimum Sub System slip Allowable: Less than",12,"Months"]
["Program critical path affected: Less than:",12,"Months"]
["Cannot meet key Milestones, if Slip is greater than:",12,"Months"]

{"sheet":"Component Summary Sheet","index":4,"n_rows":56,"n_cols":17,"rows_kept":56,"cut":false,"hidden":false,"merged":[[0,0,0,13]]}
[{"$f":"company_name&\" - \"&system_name&\" - Initial Manufacturing Risk Assessment of Components/Suppliers\"","v":"Trial Company - Trial System - Initial Manufacturing Risk Assessment of Components/Suppliers"},null,null,null,null,null,null,null,null,null,null,null,null,null,"Revision:",{"$f":"rev_date","v":"2020-07-15"},"Risk Rating"]
["Component Name","Supplier Status\n(Evaluating or Selected)","Component Technical Lead","Supplier","Materials","Cost","Design","MFG. Process","Quality","Schedule","Facilities","Supply Chain MGMT.","Industrial Base","Likelihood Score\n (1-5) \n5 Highest ","Consequence Score \n(1-5) \n5 Highest ","Weighted Impact Score (CxL)","Component Description\n(as needed)"]
["Comp 1","Evaluating",{"$f":"IF(A3<>\"\",INDIRECT(\"'\"&A3&\"'!g2\"),\"\")","v":"Engineer"},{"$f":"IF(A3<>\"\",INDIRECT(\"'\"&A3&\"'!c2\"),\"\")","v":"Supplier"},{"$f":"IF($A3<>\"\",INDIRECT(\"'\"&$A3&\"'!$B$5\"),\"\")","v":"n"},{"$f":"IF($A3<>\"\",INDIRECT(\"'\"&$A3&\"'!$B$6\"),\"\")","v":"n"},{"$f":"IF($A3<>\"\",INDIRECT(\"'\"&$A3&\"'!$B$7\"),\"\")","v":"n"},{"$f":"IF($A3<>\"\",INDIRECT(\"'\"&$A3&\"'!$B$8\"),\"\")","v":"n"},{"$f":"IF($A3<>\"\",INDIRECT(\"'\"&$A3&\"'!$B$9\"),\"\")","v":"n"},{"$f":"IF($A3<>\"\",INDIRECT(\"'\"&$A3&\"'!$B$10\"),\"\")","v":"n"},{"$f":"IF($A3<>\"\",INDIRECT(\"'\"&$A3&\"'!$B$11\"),\"\")","v":"n"},{"$f":"IF($A3<>\"\",INDIRECT(\"'\"&$A3&\"'!$B$12\"),\"\")","v":"n"},{"$f":"IF($A3<>\"\",INDIRECT(\"'\"&$A3&\"'!$B$13\"),\"\")","v":"n"},{"$f":"IF($A3<>\"\",INDIRECT(\"'\"&$A3&\"'!$g$14\"),\"\")","v":0},{"$f":"IF($A3<>\"\",INDIRECT(\"'\"&$A3&\"'!$h$14\"),\"\")","v":0},{"$f":"IF($A3<>\"\",INDIRECT(\"'\"&$A3&\"'!$j$16\"),\"\")","v":0}]
["Comp 2","Selected",{"$f":"IF(A4<>\"\",INDIRECT(\"'\"&A4&\"'!g2\"),\"\")","v":"Engineer"},{"$f":"IF(A4<>\"\",INDIRECT(\"'\"&A4&\"'!c2\"),\"\")","v":"Supplier"},{"$f":"IF($A4<>\"\",INDIRECT(\"'\"&$A4&\"'!$B$5\"),\"\")","v":"n"},{"$f":"IF($A4<>\"\",INDIRECT(\"'\"&$A4&\"'!$B$6\"),\"\")","v":"n"},{"$f":"IF($A4<>\"\",INDIRECT(\"'\"&$A4&\"'!$B$7\"),\"\")","v":"n"},{"$f":"IF($A4<>\"\",INDIRECT(\"'\"&$A4&\"'!$B$8\"),\"\")","v":"n"},{"$f":"IF($A4<>\"\",INDIRECT(\"'\"&$A4&\"'!$B$9\"),\"\")","v":"n"},{"$f":"IF($A4<>\"\",INDIRECT(\"'\"&$A4&\"'!$B$10\"),\"\")","v":"n"},{"$f":"IF($A4<>\"\",INDIRECT(\"'\"&$A4&\"'!$B$11\"),\"\")","v":"n"},{"$f":"IF($A4<>\"\",INDIRECT(\"'\"&$A4&\"'!$B$12\"),\"\")","v":"n"},{"$f":"IF($A4<>\"\",INDIRECT(\"'\"&$A4&\"'!$B$13\"),\"\")","v":"n"},{"$f":"IF($A4<>\"\",INDIRECT(\"'\"&$A4&\"'!$g$14\"),\"\")","v":0},{"$f":"IF($A4<>\"\",INDIRECT(\"'\"&$A4&\"'!$h$14\"),\"\")","v":0},{"$f":"IF($A4<>\"\",INDIRECT(\"'\"&$A4&\"'!$j$16\"),\"\")","v":0}]
["Comp 3","Selected",{"$f":"IF(A5<>\"\",INDIRECT(\"'\"&A5&\"'!g2\"),\"\")","v":"Engineer"},{"$f":"IF(A5<>\"\",INDIRECT(\"'\"&A5&\"'!c2\"),\"\")","v":"Supplier"},{"$f":"IF($A5<>\"\",INDIRECT(\"'\"&$A5&\"'!$B$5\"),\"\")","v":"n"},{"$f":"IF($A5<>\"\",INDIRECT(\"'\"&$A5&\"'!$B$6\"),\"\")","v":"n"},{"$f":"IF($A5<>\"\",INDIRECT(\"'\"&$A5&\"'!$B$7\"),\"\")","v":"n"},{"$f":"IF($A5<>\"\",INDIRECT(\"'\"&$A5&\"'!$B$8\"),\"\")","v":"n"},{"$f":"IF($A5<>\"\",INDIRECT(\"'\"&$A5&\"'!$B$9\"),\"\")","v":"n"},{"$f":"IF($A5<>\"\",INDIRECT(\"'\"&$A5&\"'!$B$10\"),\"\")","v":"n"},{"$f":"IF($A5<>\"\",INDIRECT(\"'\"&$A5&\"'!$B$11\"),\"\")","v":"n"},{"$f":"IF($A5<>\"\",INDIRECT(\"'\"&$A5&\"'!$B$12\"),\"\")","v":"n"},{"$f":"IF($A5<>\"\",INDIRECT(\"'\"&$A5&\"'!$B$13\"),\"\")","v":"n"},{"$f":"IF($A5<>\"\",INDIRECT(\"'\"&$A5&\"'!$g$14\"),\"\")","v":0},{"$f":"IF($A5<>\"\",INDIRECT(\"'\"&$A5&\"'!$h$14\"),\"\")","v":0},{"$f":"IF($A5<>\"\",INDIRECT(\"'\"&$A5&\"'!$j$16\"),\"\")","v":0}]
["Comp 4","Evaluating",{"$f":"IF(A6<>\"\",INDIRECT(\"'\"&A6&\"'!g2\"),\"\")","v":"Engineer"},{"$f":"IF(A6<>\"\",INDIRECT(\"'\"&A6&\"'!c2\"),\"\")","v":"Supplier"},{"$f":"IF($A6<>\"\",INDIRECT(\"'\"&$A6&\"'!$B$5\"),\"\")","v":"n"},{"$f":"IF($A6<>\"\",INDIRECT(\"'\"&$A6&\"'!$B$6\"),\"\")","v":"n"},{"$f":"IF($A6<>\"\",INDIRECT(\"'\"&$A6&\"'!$B$7\"),\"\")","v":"n"},{"$f":"IF($A6<>\"\",INDIRECT(\"'\"&$A6&\"'!$B$8\"),\"\")","v":"n"},{"$f":"IF($A6<>\"\",INDIRECT(\"'\"&$A6&\"'!$B$9\"),\"\")","v":"n"},{"$f":"IF($A6<>\"\",INDIRECT(\"'\"&$A6&\"'!$B$10\"),\"\")","v":"n"},{"$f":"IF($A6<>\"\",INDIRECT(\"'\"&$A6&\"'!$B$11\"),\"\")","v":"n"},{"$f":"IF($A6<>\"\",INDIRECT(\"'\"&$A6&\"'!$B$12\"),\"\")","v":"n"},{"$f":"IF($A6<>\"\",INDIRECT(\"'\"&$A6&\"'!$B$13\"),\"\")","v":"n"},{"$f":"IF($A6<>\"\",INDIRECT(\"'\"&$A6&\"'!$g$14\"),\"\")","v":0},{"$f":"IF($A6<>\"\",INDIRECT(\"'\"&$A6&\"'!$h$14\"),\"\")","v":0},{"$f":"IF($A6<>\"\",INDIRECT(\"'\"&$A6&\"'!$j$16\"),\"\")","v":0}]
["Comp 5","Evaluating",{"$f":"IF(A7<>\"\",INDIRECT(\"'\"&A7&\"'!g2\"),\"\")","v":"Engineer"},{"$f":"IF(A7<>\"\",INDIRECT(\"'\"&A7&\"'!c2\"),\"\")","v":"Supplier"},{"$f":"IF($A7<>\"\",INDIRECT(\"'\"&$A7&\"'!$B$5\"),\"\")","v":"n"},{"$f":"IF($A7<>\"\",INDIRECT(\"'\"&$A7&\"'!$B$6\"),\"\")","v":"n"},{"$f":"IF($A7<>\"\",INDIRECT(\"'\"&$A7&\"'!$B$7\"),\"\")","v":"n"},{"$f":"IF($A7<>\"\",INDIRECT(\"'\"&$A7&\"'!$B$8\"),\"\")","v":"n"},{"$f":"IF($A7<>\"\",INDIRECT(\"'\"&$A7&\"'!$B$9\"),\"\")","v":"n"},{"$f":"IF($A7<>\"\",INDIRECT(\"'\"&$A7&\"'!$B$10\"),\"\")","v":"n"},{"$f":"IF($A7<>\"\",INDIRECT(\"'\"&$A7&\"'!$B$11\"),\"\")","v":"n"},{"$f":"IF($A7<>\"\",INDIRECT(\"'\"&$A7&\"'!$B$12\"),\"\")","v":"n"},{"$f":"IF($A7<>\"\",INDIRECT(\"'\"&$A7&\"'!$B$13\"),\"\")","v":"n"},{"$f":"IF($A7<>\"\",INDIRECT(\"'\"&$A7&\"'!$g$14\"),\"\")","v":0},{"$f":"IF($A7<>\"\",INDIRECT(\"'\"&$A7&\"'!$h$14\"),\"\")","v":0},{"$f":"IF($A7<>\"\",INDIRECT(\"'\"&$A7&\"'!$j$16\"),\"\")","v":0}]
[null,null,{"$f":"IF(A8<>\"\",INDIRECT(\"'\"&A8&\"'!g2\"),\"\")","v":""},{"$f":"IF(A8<>\"\",INDIRECT(\"'\"&A8&\"'!c2\"),\"\")","v":""},{"$f":"IF($A8<>\"\",INDIRECT(\"'\"&$A8&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A8<>\"\",INDIRECT(\"'\"&$A8&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A8<>\"\",INDIRECT(\"'\"&$A8&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A8<>\"\",INDIRECT(\"'\"&$A8&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A8<>\"\",INDIRECT(\"'\"&$A8&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A8<>\"\",INDIRECT(\"'\"&$A8&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A8<>\"\",INDIRECT(\"'\"&$A8&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A8<>\"\",INDIRECT(\"'\"&$A8&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A8<>\"\",INDIRECT(\"'\"&$A8&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A8<>\"\",INDIRECT(\"'\"&$A8&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A8<>\"\",INDIRECT(\"'\"&$A8&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A8<>\"\",INDIRECT(\"'\"&$A8&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A9<>\"\",INDIRECT(\"'\"&A9&\"'!g2\"),\"\")","v":""},{"$f":"IF(A9<>\"\",INDIRECT(\"'\"&A9&\"'!c2\"),\"\")","v":""},{"$f":"IF($A9<>\"\",INDIRECT(\"'\"&$A9&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A9<>\"\",INDIRECT(\"'\"&$A9&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A9<>\"\",INDIRECT(\"'\"&$A9&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A9<>\"\",INDIRECT(\"'\"&$A9&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A9<>\"\",INDIRECT(\"'\"&$A9&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A9<>\"\",INDIRECT(\"'\"&$A9&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A9<>\"\",INDIRECT(\"'\"&$A9&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A9<>\"\",INDIRECT(\"'\"&$A9&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A9<>\"\",INDIRECT(\"'\"&$A9&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A9<>\"\",INDIRECT(\"'\"&$A9&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A9<>\"\",INDIRECT(\"'\"&$A9&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A9<>\"\",INDIRECT(\"'\"&$A9&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A10<>\"\",INDIRECT(\"'\"&A10&\"'!g2\"),\"\")","v":""},{"$f":"IF(A10<>\"\",INDIRECT(\"'\"&A10&\"'!c2\"),\"\")","v":""},{"$f":"IF($A10<>\"\",INDIRECT(\"'\"&$A10&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A10<>\"\",INDIRECT(\"'\"&$A10&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A10<>\"\",INDIRECT(\"'\"&$A10&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A10<>\"\",INDIRECT(\"'\"&$A10&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A10<>\"\",INDIRECT(\"'\"&$A10&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A10<>\"\",INDIRECT(\"'\"&$A10&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A10<>\"\",INDIRECT(\"'\"&$A10&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A10<>\"\",INDIRECT(\"'\"&$A10&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A10<>\"\",INDIRECT(\"'\"&$A10&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A10<>\"\",INDIRECT(\"'\"&$A10&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A10<>\"\",INDIRECT(\"'\"&$A10&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A10<>\"\",INDIRECT(\"'\"&$A10&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A11<>\"\",INDIRECT(\"'\"&A11&\"'!g2\"),\"\")","v":""},{"$f":"IF(A11<>\"\",INDIRECT(\"'\"&A11&\"'!c2\"),\"\")","v":""},{"$f":"IF($A11<>\"\",INDIRECT(\"'\"&$A11&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A11<>\"\",INDIRECT(\"'\"&$A11&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A11<>\"\",INDIRECT(\"'\"&$A11&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A11<>\"\",INDIRECT(\"'\"&$A11&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A11<>\"\",INDIRECT(\"'\"&$A11&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A11<>\"\",INDIRECT(\"'\"&$A11&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A11<>\"\",INDIRECT(\"'\"&$A11&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A11<>\"\",INDIRECT(\"'\"&$A11&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A11<>\"\",INDIRECT(\"'\"&$A11&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A11<>\"\",INDIRECT(\"'\"&$A11&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A11<>\"\",INDIRECT(\"'\"&$A11&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A11<>\"\",INDIRECT(\"'\"&$A11&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A12<>\"\",INDIRECT(\"'\"&A12&\"'!g2\"),\"\")","v":""},{"$f":"IF(A12<>\"\",INDIRECT(\"'\"&A12&\"'!c2\"),\"\")","v":""},{"$f":"IF($A12<>\"\",INDIRECT(\"'\"&$A12&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A12<>\"\",INDIRECT(\"'\"&$A12&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A12<>\"\",INDIRECT(\"'\"&$A12&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A12<>\"\",INDIRECT(\"'\"&$A12&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A12<>\"\",INDIRECT(\"'\"&$A12&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A12<>\"\",INDIRECT(\"'\"&$A12&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A12<>\"\",INDIRECT(\"'\"&$A12&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A12<>\"\",INDIRECT(\"'\"&$A12&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A12<>\"\",INDIRECT(\"'\"&$A12&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A12<>\"\",INDIRECT(\"'\"&$A12&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A12<>\"\",INDIRECT(\"'\"&$A12&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A12<>\"\",INDIRECT(\"'\"&$A12&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A13<>\"\",INDIRECT(\"'\"&A13&\"'!g2\"),\"\")","v":""},{"$f":"IF(A13<>\"\",INDIRECT(\"'\"&A13&\"'!c2\"),\"\")","v":""},{"$f":"IF($A13<>\"\",INDIRECT(\"'\"&$A13&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A13<>\"\",INDIRECT(\"'\"&$A13&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A13<>\"\",INDIRECT(\"'\"&$A13&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A13<>\"\",INDIRECT(\"'\"&$A13&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A13<>\"\",INDIRECT(\"'\"&$A13&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A13<>\"\",INDIRECT(\"'\"&$A13&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A13<>\"\",INDIRECT(\"'\"&$A13&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A13<>\"\",INDIRECT(\"'\"&$A13&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A13<>\"\",INDIRECT(\"'\"&$A13&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A13<>\"\",INDIRECT(\"'\"&$A13&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A13<>\"\",INDIRECT(\"'\"&$A13&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A13<>\"\",INDIRECT(\"'\"&$A13&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A14<>\"\",INDIRECT(\"'\"&A14&\"'!g2\"),\"\")","v":""},{"$f":"IF(A14<>\"\",INDIRECT(\"'\"&A14&\"'!c2\"),\"\")","v":""},{"$f":"IF($A14<>\"\",INDIRECT(\"'\"&$A14&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A14<>\"\",INDIRECT(\"'\"&$A14&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A14<>\"\",INDIRECT(\"'\"&$A14&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A14<>\"\",INDIRECT(\"'\"&$A14&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A14<>\"\",INDIRECT(\"'\"&$A14&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A14<>\"\",INDIRECT(\"'\"&$A14&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A14<>\"\",INDIRECT(\"'\"&$A14&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A14<>\"\",INDIRECT(\"'\"&$A14&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A14<>\"\",INDIRECT(\"'\"&$A14&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A14<>\"\",INDIRECT(\"'\"&$A14&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A14<>\"\",INDIRECT(\"'\"&$A14&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A14<>\"\",INDIRECT(\"'\"&$A14&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A15<>\"\",INDIRECT(\"'\"&A15&\"'!g2\"),\"\")","v":""},{"$f":"IF(A15<>\"\",INDIRECT(\"'\"&A15&\"'!c2\"),\"\")","v":""},{"$f":"IF($A15<>\"\",INDIRECT(\"'\"&$A15&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A15<>\"\",INDIRECT(\"'\"&$A15&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A15<>\"\",INDIRECT(\"'\"&$A15&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A15<>\"\",INDIRECT(\"'\"&$A15&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A15<>\"\",INDIRECT(\"'\"&$A15&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A15<>\"\",INDIRECT(\"'\"&$A15&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A15<>\"\",INDIRECT(\"'\"&$A15&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A15<>\"\",INDIRECT(\"'\"&$A15&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A15<>\"\",INDIRECT(\"'\"&$A15&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A15<>\"\",INDIRECT(\"'\"&$A15&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A15<>\"\",INDIRECT(\"'\"&$A15&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A15<>\"\",INDIRECT(\"'\"&$A15&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A16<>\"\",INDIRECT(\"'\"&A16&\"'!g2\"),\"\")","v":""},{"$f":"IF(A16<>\"\",INDIRECT(\"'\"&A16&\"'!c2\"),\"\")","v":""},{"$f":"IF($A16<>\"\",INDIRECT(\"'\"&$A16&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A16<>\"\",INDIRECT(\"'\"&$A16&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A16<>\"\",INDIRECT(\"'\"&$A16&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A16<>\"\",INDIRECT(\"'\"&$A16&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A16<>\"\",INDIRECT(\"'\"&$A16&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A16<>\"\",INDIRECT(\"'\"&$A16&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A16<>\"\",INDIRECT(\"'\"&$A16&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A16<>\"\",INDIRECT(\"'\"&$A16&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A16<>\"\",INDIRECT(\"'\"&$A16&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A16<>\"\",INDIRECT(\"'\"&$A16&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A16<>\"\",INDIRECT(\"'\"&$A16&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A16<>\"\",INDIRECT(\"'\"&$A16&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A17<>\"\",INDIRECT(\"'\"&A17&\"'!g2\"),\"\")","v":""},{"$f":"IF(A17<>\"\",INDIRECT(\"'\"&A17&\"'!c2\"),\"\")","v":""},{"$f":"IF($A17<>\"\",INDIRECT(\"'\"&$A17&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A17<>\"\",INDIRECT(\"'\"&$A17&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A17<>\"\",INDIRECT(\"'\"&$A17&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A17<>\"\",INDIRECT(\"'\"&$A17&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A17<>\"\",INDIRECT(\"'\"&$A17&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A17<>\"\",INDIRECT(\"'\"&$A17&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A17<>\"\",INDIRECT(\"'\"&$A17&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A17<>\"\",INDIRECT(\"'\"&$A17&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A17<>\"\",INDIRECT(\"'\"&$A17&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A17<>\"\",INDIRECT(\"'\"&$A17&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A17<>\"\",INDIRECT(\"'\"&$A17&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A17<>\"\",INDIRECT(\"'\"&$A17&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A18<>\"\",INDIRECT(\"'\"&A18&\"'!g2\"),\"\")","v":""},{"$f":"IF(A18<>\"\",INDIRECT(\"'\"&A18&\"'!c2\"),\"\")","v":""},{"$f":"IF($A18<>\"\",INDIRECT(\"'\"&$A18&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A18<>\"\",INDIRECT(\"'\"&$A18&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A18<>\"\",INDIRECT(\"'\"&$A18&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A18<>\"\",INDIRECT(\"'\"&$A18&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A18<>\"\",INDIRECT(\"'\"&$A18&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A18<>\"\",INDIRECT(\"'\"&$A18&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A18<>\"\",INDIRECT(\"'\"&$A18&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A18<>\"\",INDIRECT(\"'\"&$A18&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A18<>\"\",INDIRECT(\"'\"&$A18&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A18<>\"\",INDIRECT(\"'\"&$A18&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A18<>\"\",INDIRECT(\"'\"&$A18&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A18<>\"\",INDIRECT(\"'\"&$A18&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A19<>\"\",INDIRECT(\"'\"&A19&\"'!g2\"),\"\")","v":""},{"$f":"IF(A19<>\"\",INDIRECT(\"'\"&A19&\"'!c2\"),\"\")","v":""},{"$f":"IF($A19<>\"\",INDIRECT(\"'\"&$A19&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A19<>\"\",INDIRECT(\"'\"&$A19&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A19<>\"\",INDIRECT(\"'\"&$A19&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A19<>\"\",INDIRECT(\"'\"&$A19&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A19<>\"\",INDIRECT(\"'\"&$A19&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A19<>\"\",INDIRECT(\"'\"&$A19&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A19<>\"\",INDIRECT(\"'\"&$A19&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A19<>\"\",INDIRECT(\"'\"&$A19&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A19<>\"\",INDIRECT(\"'\"&$A19&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A19<>\"\",INDIRECT(\"'\"&$A19&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A19<>\"\",INDIRECT(\"'\"&$A19&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A19<>\"\",INDIRECT(\"'\"&$A19&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A20<>\"\",INDIRECT(\"'\"&A20&\"'!g2\"),\"\")","v":""},{"$f":"IF(A20<>\"\",INDIRECT(\"'\"&A20&\"'!c2\"),\"\")","v":""},{"$f":"IF($A20<>\"\",INDIRECT(\"'\"&$A20&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A20<>\"\",INDIRECT(\"'\"&$A20&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A20<>\"\",INDIRECT(\"'\"&$A20&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A20<>\"\",INDIRECT(\"'\"&$A20&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A20<>\"\",INDIRECT(\"'\"&$A20&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A20<>\"\",INDIRECT(\"'\"&$A20&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A20<>\"\",INDIRECT(\"'\"&$A20&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A20<>\"\",INDIRECT(\"'\"&$A20&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A20<>\"\",INDIRECT(\"'\"&$A20&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A20<>\"\",INDIRECT(\"'\"&$A20&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A20<>\"\",INDIRECT(\"'\"&$A20&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A20<>\"\",INDIRECT(\"'\"&$A20&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A21<>\"\",INDIRECT(\"'\"&A21&\"'!g2\"),\"\")","v":""},{"$f":"IF(A21<>\"\",INDIRECT(\"'\"&A21&\"'!c2\"),\"\")","v":""},{"$f":"IF($A21<>\"\",INDIRECT(\"'\"&$A21&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A21<>\"\",INDIRECT(\"'\"&$A21&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A21<>\"\",INDIRECT(\"'\"&$A21&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A21<>\"\",INDIRECT(\"'\"&$A21&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A21<>\"\",INDIRECT(\"'\"&$A21&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A21<>\"\",INDIRECT(\"'\"&$A21&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A21<>\"\",INDIRECT(\"'\"&$A21&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A21<>\"\",INDIRECT(\"'\"&$A21&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A21<>\"\",INDIRECT(\"'\"&$A21&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A21<>\"\",INDIRECT(\"'\"&$A21&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A21<>\"\",INDIRECT(\"'\"&$A21&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A21<>\"\",INDIRECT(\"'\"&$A21&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A22<>\"\",INDIRECT(\"'\"&A22&\"'!g2\"),\"\")","v":""},{"$f":"IF(A22<>\"\",INDIRECT(\"'\"&A22&\"'!c2\"),\"\")","v":""},{"$f":"IF($A22<>\"\",INDIRECT(\"'\"&$A22&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A22<>\"\",INDIRECT(\"'\"&$A22&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A22<>\"\",INDIRECT(\"'\"&$A22&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A22<>\"\",INDIRECT(\"'\"&$A22&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A22<>\"\",INDIRECT(\"'\"&$A22&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A22<>\"\",INDIRECT(\"'\"&$A22&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A22<>\"\",INDIRECT(\"'\"&$A22&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A22<>\"\",INDIRECT(\"'\"&$A22&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A22<>\"\",INDIRECT(\"'\"&$A22&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A22<>\"\",INDIRECT(\"'\"&$A22&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A22<>\"\",INDIRECT(\"'\"&$A22&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A22<>\"\",INDIRECT(\"'\"&$A22&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A23<>\"\",INDIRECT(\"'\"&A23&\"'!g2\"),\"\")","v":""},{"$f":"IF(A23<>\"\",INDIRECT(\"'\"&A23&\"'!c2\"),\"\")","v":""},{"$f":"IF($A23<>\"\",INDIRECT(\"'\"&$A23&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A23<>\"\",INDIRECT(\"'\"&$A23&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A23<>\"\",INDIRECT(\"'\"&$A23&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A23<>\"\",INDIRECT(\"'\"&$A23&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A23<>\"\",INDIRECT(\"'\"&$A23&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A23<>\"\",INDIRECT(\"'\"&$A23&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A23<>\"\",INDIRECT(\"'\"&$A23&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A23<>\"\",INDIRECT(\"'\"&$A23&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A23<>\"\",INDIRECT(\"'\"&$A23&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A23<>\"\",INDIRECT(\"'\"&$A23&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A23<>\"\",INDIRECT(\"'\"&$A23&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A23<>\"\",INDIRECT(\"'\"&$A23&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A24<>\"\",INDIRECT(\"'\"&A24&\"'!g2\"),\"\")","v":""},{"$f":"IF(A24<>\"\",INDIRECT(\"'\"&A24&\"'!c2\"),\"\")","v":""},{"$f":"IF($A24<>\"\",INDIRECT(\"'\"&$A24&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A24<>\"\",INDIRECT(\"'\"&$A24&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A24<>\"\",INDIRECT(\"'\"&$A24&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A24<>\"\",INDIRECT(\"'\"&$A24&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A24<>\"\",INDIRECT(\"'\"&$A24&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A24<>\"\",INDIRECT(\"'\"&$A24&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A24<>\"\",INDIRECT(\"'\"&$A24&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A24<>\"\",INDIRECT(\"'\"&$A24&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A24<>\"\",INDIRECT(\"'\"&$A24&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A24<>\"\",INDIRECT(\"'\"&$A24&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A24<>\"\",INDIRECT(\"'\"&$A24&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A24<>\"\",INDIRECT(\"'\"&$A24&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A25<>\"\",INDIRECT(\"'\"&A25&\"'!g2\"),\"\")","v":""},{"$f":"IF(A25<>\"\",INDIRECT(\"'\"&A25&\"'!c2\"),\"\")","v":""},{"$f":"IF($A25<>\"\",INDIRECT(\"'\"&$A25&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A25<>\"\",INDIRECT(\"'\"&$A25&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A25<>\"\",INDIRECT(\"'\"&$A25&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A25<>\"\",INDIRECT(\"'\"&$A25&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A25<>\"\",INDIRECT(\"'\"&$A25&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A25<>\"\",INDIRECT(\"'\"&$A25&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A25<>\"\",INDIRECT(\"'\"&$A25&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A25<>\"\",INDIRECT(\"'\"&$A25&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A25<>\"\",INDIRECT(\"'\"&$A25&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A25<>\"\",INDIRECT(\"'\"&$A25&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A25<>\"\",INDIRECT(\"'\"&$A25&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A25<>\"\",INDIRECT(\"'\"&$A25&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A26<>\"\",INDIRECT(\"'\"&A26&\"'!g2\"),\"\")","v":""},{"$f":"IF(A26<>\"\",INDIRECT(\"'\"&A26&\"'!c2\"),\"\")","v":""},{"$f":"IF($A26<>\"\",INDIRECT(\"'\"&$A26&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A26<>\"\",INDIRECT(\"'\"&$A26&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A26<>\"\",INDIRECT(\"'\"&$A26&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A26<>\"\",INDIRECT(\"'\"&$A26&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A26<>\"\",INDIRECT(\"'\"&$A26&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A26<>\"\",INDIRECT(\"'\"&$A26&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A26<>\"\",INDIRECT(\"'\"&$A26&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A26<>\"\",INDIRECT(\"'\"&$A26&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A26<>\"\",INDIRECT(\"'\"&$A26&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A26<>\"\",INDIRECT(\"'\"&$A26&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A26<>\"\",INDIRECT(\"'\"&$A26&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A26<>\"\",INDIRECT(\"'\"&$A26&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A27<>\"\",INDIRECT(\"'\"&A27&\"'!g2\"),\"\")","v":""},{"$f":"IF(A27<>\"\",INDIRECT(\"'\"&A27&\"'!c2\"),\"\")","v":""},{"$f":"IF($A27<>\"\",INDIRECT(\"'\"&$A27&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A27<>\"\",INDIRECT(\"'\"&$A27&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A27<>\"\",INDIRECT(\"'\"&$A27&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A27<>\"\",INDIRECT(\"'\"&$A27&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A27<>\"\",INDIRECT(\"'\"&$A27&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A27<>\"\",INDIRECT(\"'\"&$A27&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A27<>\"\",INDIRECT(\"'\"&$A27&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A27<>\"\",INDIRECT(\"'\"&$A27&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A27<>\"\",INDIRECT(\"'\"&$A27&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A27<>\"\",INDIRECT(\"'\"&$A27&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A27<>\"\",INDIRECT(\"'\"&$A27&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A27<>\"\",INDIRECT(\"'\"&$A27&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A28<>\"\",INDIRECT(\"'\"&A28&\"'!g2\"),\"\")","v":""},{"$f":"IF(A28<>\"\",INDIRECT(\"'\"&A28&\"'!c2\"),\"\")","v":""},{"$f":"IF($A28<>\"\",INDIRECT(\"'\"&$A28&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A28<>\"\",INDIRECT(\"'\"&$A28&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A28<>\"\",INDIRECT(\"'\"&$A28&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A28<>\"\",INDIRECT(\"'\"&$A28&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A28<>\"\",INDIRECT(\"'\"&$A28&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A28<>\"\",INDIRECT(\"'\"&$A28&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A28<>\"\",INDIRECT(\"'\"&$A28&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A28<>\"\",INDIRECT(\"'\"&$A28&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A28<>\"\",INDIRECT(\"'\"&$A28&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A28<>\"\",INDIRECT(\"'\"&$A28&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A28<>\"\",INDIRECT(\"'\"&$A28&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A28<>\"\",INDIRECT(\"'\"&$A28&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A29<>\"\",INDIRECT(\"'\"&A29&\"'!g2\"),\"\")","v":""},{"$f":"IF(A29<>\"\",INDIRECT(\"'\"&A29&\"'!c2\"),\"\")","v":""},{"$f":"IF($A29<>\"\",INDIRECT(\"'\"&$A29&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A29<>\"\",INDIRECT(\"'\"&$A29&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A29<>\"\",INDIRECT(\"'\"&$A29&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A29<>\"\",INDIRECT(\"'\"&$A29&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A29<>\"\",INDIRECT(\"'\"&$A29&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A29<>\"\",INDIRECT(\"'\"&$A29&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A29<>\"\",INDIRECT(\"'\"&$A29&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A29<>\"\",INDIRECT(\"'\"&$A29&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A29<>\"\",INDIRECT(\"'\"&$A29&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A29<>\"\",INDIRECT(\"'\"&$A29&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A29<>\"\",INDIRECT(\"'\"&$A29&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A29<>\"\",INDIRECT(\"'\"&$A29&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A30<>\"\",INDIRECT(\"'\"&A30&\"'!g2\"),\"\")","v":""},{"$f":"IF(A30<>\"\",INDIRECT(\"'\"&A30&\"'!c2\"),\"\")","v":""},{"$f":"IF($A30<>\"\",INDIRECT(\"'\"&$A30&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A30<>\"\",INDIRECT(\"'\"&$A30&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A30<>\"\",INDIRECT(\"'\"&$A30&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A30<>\"\",INDIRECT(\"'\"&$A30&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A30<>\"\",INDIRECT(\"'\"&$A30&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A30<>\"\",INDIRECT(\"'\"&$A30&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A30<>\"\",INDIRECT(\"'\"&$A30&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A30<>\"\",INDIRECT(\"'\"&$A30&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A30<>\"\",INDIRECT(\"'\"&$A30&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A30<>\"\",INDIRECT(\"'\"&$A30&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A30<>\"\",INDIRECT(\"'\"&$A30&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A30<>\"\",INDIRECT(\"'\"&$A30&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A31<>\"\",INDIRECT(\"'\"&A31&\"'!g2\"),\"\")","v":""},{"$f":"IF(A31<>\"\",INDIRECT(\"'\"&A31&\"'!c2\"),\"\")","v":""},{"$f":"IF($A31<>\"\",INDIRECT(\"'\"&$A31&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A31<>\"\",INDIRECT(\"'\"&$A31&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A31<>\"\",INDIRECT(\"'\"&$A31&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A31<>\"\",INDIRECT(\"'\"&$A31&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A31<>\"\",INDIRECT(\"'\"&$A31&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A31<>\"\",INDIRECT(\"'\"&$A31&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A31<>\"\",INDIRECT(\"'\"&$A31&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A31<>\"\",INDIRECT(\"'\"&$A31&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A31<>\"\",INDIRECT(\"'\"&$A31&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A31<>\"\",INDIRECT(\"'\"&$A31&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A31<>\"\",INDIRECT(\"'\"&$A31&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A31<>\"\",INDIRECT(\"'\"&$A31&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A32<>\"\",INDIRECT(\"'\"&A32&\"'!g2\"),\"\")","v":""},{"$f":"IF(A32<>\"\",INDIRECT(\"'\"&A32&\"'!c2\"),\"\")","v":""},{"$f":"IF($A32<>\"\",INDIRECT(\"'\"&$A32&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A32<>\"\",INDIRECT(\"'\"&$A32&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A32<>\"\",INDIRECT(\"'\"&$A32&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A32<>\"\",INDIRECT(\"'\"&$A32&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A32<>\"\",INDIRECT(\"'\"&$A32&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A32<>\"\",INDIRECT(\"'\"&$A32&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A32<>\"\",INDIRECT(\"'\"&$A32&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A32<>\"\",INDIRECT(\"'\"&$A32&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A32<>\"\",INDIRECT(\"'\"&$A32&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A32<>\"\",INDIRECT(\"'\"&$A32&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A32<>\"\",INDIRECT(\"'\"&$A32&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A32<>\"\",INDIRECT(\"'\"&$A32&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A33<>\"\",INDIRECT(\"'\"&A33&\"'!g2\"),\"\")","v":""},{"$f":"IF(A33<>\"\",INDIRECT(\"'\"&A33&\"'!c2\"),\"\")","v":""},{"$f":"IF($A33<>\"\",INDIRECT(\"'\"&$A33&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A33<>\"\",INDIRECT(\"'\"&$A33&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A33<>\"\",INDIRECT(\"'\"&$A33&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A33<>\"\",INDIRECT(\"'\"&$A33&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A33<>\"\",INDIRECT(\"'\"&$A33&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A33<>\"\",INDIRECT(\"'\"&$A33&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A33<>\"\",INDIRECT(\"'\"&$A33&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A33<>\"\",INDIRECT(\"'\"&$A33&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A33<>\"\",INDIRECT(\"'\"&$A33&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A33<>\"\",INDIRECT(\"'\"&$A33&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A33<>\"\",INDIRECT(\"'\"&$A33&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A33<>\"\",INDIRECT(\"'\"&$A33&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A34<>\"\",INDIRECT(\"'\"&A34&\"'!g2\"),\"\")","v":""},{"$f":"IF(A34<>\"\",INDIRECT(\"'\"&A34&\"'!c2\"),\"\")","v":""},{"$f":"IF($A34<>\"\",INDIRECT(\"'\"&$A34&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A34<>\"\",INDIRECT(\"'\"&$A34&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A34<>\"\",INDIRECT(\"'\"&$A34&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A34<>\"\",INDIRECT(\"'\"&$A34&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A34<>\"\",INDIRECT(\"'\"&$A34&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A34<>\"\",INDIRECT(\"'\"&$A34&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A34<>\"\",INDIRECT(\"'\"&$A34&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A34<>\"\",INDIRECT(\"'\"&$A34&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A34<>\"\",INDIRECT(\"'\"&$A34&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A34<>\"\",INDIRECT(\"'\"&$A34&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A34<>\"\",INDIRECT(\"'\"&$A34&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A34<>\"\",INDIRECT(\"'\"&$A34&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A35<>\"\",INDIRECT(\"'\"&A35&\"'!g2\"),\"\")","v":""},{"$f":"IF(A35<>\"\",INDIRECT(\"'\"&A35&\"'!c2\"),\"\")","v":""},{"$f":"IF($A35<>\"\",INDIRECT(\"'\"&$A35&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A35<>\"\",INDIRECT(\"'\"&$A35&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A35<>\"\",INDIRECT(\"'\"&$A35&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A35<>\"\",INDIRECT(\"'\"&$A35&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A35<>\"\",INDIRECT(\"'\"&$A35&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A35<>\"\",INDIRECT(\"'\"&$A35&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A35<>\"\",INDIRECT(\"'\"&$A35&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A35<>\"\",INDIRECT(\"'\"&$A35&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A35<>\"\",INDIRECT(\"'\"&$A35&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A35<>\"\",INDIRECT(\"'\"&$A35&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A35<>\"\",INDIRECT(\"'\"&$A35&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A35<>\"\",INDIRECT(\"'\"&$A35&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A36<>\"\",INDIRECT(\"'\"&A36&\"'!g2\"),\"\")","v":""},{"$f":"IF(A36<>\"\",INDIRECT(\"'\"&A36&\"'!c2\"),\"\")","v":""},{"$f":"IF($A36<>\"\",INDIRECT(\"'\"&$A36&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A36<>\"\",INDIRECT(\"'\"&$A36&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A36<>\"\",INDIRECT(\"'\"&$A36&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A36<>\"\",INDIRECT(\"'\"&$A36&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A36<>\"\",INDIRECT(\"'\"&$A36&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A36<>\"\",INDIRECT(\"'\"&$A36&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A36<>\"\",INDIRECT(\"'\"&$A36&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A36<>\"\",INDIRECT(\"'\"&$A36&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A36<>\"\",INDIRECT(\"'\"&$A36&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A36<>\"\",INDIRECT(\"'\"&$A36&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A36<>\"\",INDIRECT(\"'\"&$A36&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A36<>\"\",INDIRECT(\"'\"&$A36&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A37<>\"\",INDIRECT(\"'\"&A37&\"'!g2\"),\"\")","v":""},{"$f":"IF(A37<>\"\",INDIRECT(\"'\"&A37&\"'!c2\"),\"\")","v":""},{"$f":"IF($A37<>\"\",INDIRECT(\"'\"&$A37&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A37<>\"\",INDIRECT(\"'\"&$A37&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A37<>\"\",INDIRECT(\"'\"&$A37&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A37<>\"\",INDIRECT(\"'\"&$A37&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A37<>\"\",INDIRECT(\"'\"&$A37&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A37<>\"\",INDIRECT(\"'\"&$A37&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A37<>\"\",INDIRECT(\"'\"&$A37&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A37<>\"\",INDIRECT(\"'\"&$A37&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A37<>\"\",INDIRECT(\"'\"&$A37&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A37<>\"\",INDIRECT(\"'\"&$A37&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A37<>\"\",INDIRECT(\"'\"&$A37&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A37<>\"\",INDIRECT(\"'\"&$A37&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A38<>\"\",INDIRECT(\"'\"&A38&\"'!g2\"),\"\")","v":""},{"$f":"IF(A38<>\"\",INDIRECT(\"'\"&A38&\"'!c2\"),\"\")","v":""},{"$f":"IF($A38<>\"\",INDIRECT(\"'\"&$A38&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A38<>\"\",INDIRECT(\"'\"&$A38&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A38<>\"\",INDIRECT(\"'\"&$A38&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A38<>\"\",INDIRECT(\"'\"&$A38&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A38<>\"\",INDIRECT(\"'\"&$A38&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A38<>\"\",INDIRECT(\"'\"&$A38&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A38<>\"\",INDIRECT(\"'\"&$A38&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A38<>\"\",INDIRECT(\"'\"&$A38&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A38<>\"\",INDIRECT(\"'\"&$A38&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A38<>\"\",INDIRECT(\"'\"&$A38&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A38<>\"\",INDIRECT(\"'\"&$A38&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A38<>\"\",INDIRECT(\"'\"&$A38&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A39<>\"\",INDIRECT(\"'\"&A39&\"'!g2\"),\"\")","v":""},{"$f":"IF(A39<>\"\",INDIRECT(\"'\"&A39&\"'!c2\"),\"\")","v":""},{"$f":"IF($A39<>\"\",INDIRECT(\"'\"&$A39&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A39<>\"\",INDIRECT(\"'\"&$A39&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A39<>\"\",INDIRECT(\"'\"&$A39&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A39<>\"\",INDIRECT(\"'\"&$A39&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A39<>\"\",INDIRECT(\"'\"&$A39&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A39<>\"\",INDIRECT(\"'\"&$A39&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A39<>\"\",INDIRECT(\"'\"&$A39&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A39<>\"\",INDIRECT(\"'\"&$A39&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A39<>\"\",INDIRECT(\"'\"&$A39&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A39<>\"\",INDIRECT(\"'\"&$A39&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A39<>\"\",INDIRECT(\"'\"&$A39&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A39<>\"\",INDIRECT(\"'\"&$A39&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A40<>\"\",INDIRECT(\"'\"&A40&\"'!g2\"),\"\")","v":""},{"$f":"IF(A40<>\"\",INDIRECT(\"'\"&A40&\"'!c2\"),\"\")","v":""},{"$f":"IF($A40<>\"\",INDIRECT(\"'\"&$A40&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A40<>\"\",INDIRECT(\"'\"&$A40&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A40<>\"\",INDIRECT(\"'\"&$A40&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A40<>\"\",INDIRECT(\"'\"&$A40&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A40<>\"\",INDIRECT(\"'\"&$A40&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A40<>\"\",INDIRECT(\"'\"&$A40&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A40<>\"\",INDIRECT(\"'\"&$A40&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A40<>\"\",INDIRECT(\"'\"&$A40&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A40<>\"\",INDIRECT(\"'\"&$A40&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A40<>\"\",INDIRECT(\"'\"&$A40&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A40<>\"\",INDIRECT(\"'\"&$A40&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A40<>\"\",INDIRECT(\"'\"&$A40&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A41<>\"\",INDIRECT(\"'\"&A41&\"'!g2\"),\"\")","v":""},{"$f":"IF(A41<>\"\",INDIRECT(\"'\"&A41&\"'!c2\"),\"\")","v":""},{"$f":"IF($A41<>\"\",INDIRECT(\"'\"&$A41&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A41<>\"\",INDIRECT(\"'\"&$A41&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A41<>\"\",INDIRECT(\"'\"&$A41&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A41<>\"\",INDIRECT(\"'\"&$A41&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A41<>\"\",INDIRECT(\"'\"&$A41&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A41<>\"\",INDIRECT(\"'\"&$A41&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A41<>\"\",INDIRECT(\"'\"&$A41&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A41<>\"\",INDIRECT(\"'\"&$A41&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A41<>\"\",INDIRECT(\"'\"&$A41&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A41<>\"\",INDIRECT(\"'\"&$A41&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A41<>\"\",INDIRECT(\"'\"&$A41&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A41<>\"\",INDIRECT(\"'\"&$A41&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A42<>\"\",INDIRECT(\"'\"&A42&\"'!g2\"),\"\")","v":""},{"$f":"IF(A42<>\"\",INDIRECT(\"'\"&A42&\"'!c2\"),\"\")","v":""},{"$f":"IF($A42<>\"\",INDIRECT(\"'\"&$A42&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A42<>\"\",INDIRECT(\"'\"&$A42&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A42<>\"\",INDIRECT(\"'\"&$A42&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A42<>\"\",INDIRECT(\"'\"&$A42&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A42<>\"\",INDIRECT(\"'\"&$A42&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A42<>\"\",INDIRECT(\"'\"&$A42&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A42<>\"\",INDIRECT(\"'\"&$A42&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A42<>\"\",INDIRECT(\"'\"&$A42&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A42<>\"\",INDIRECT(\"'\"&$A42&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A42<>\"\",INDIRECT(\"'\"&$A42&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A42<>\"\",INDIRECT(\"'\"&$A42&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A42<>\"\",INDIRECT(\"'\"&$A42&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A43<>\"\",INDIRECT(\"'\"&A43&\"'!g2\"),\"\")","v":""},{"$f":"IF(A43<>\"\",INDIRECT(\"'\"&A43&\"'!c2\"),\"\")","v":""},{"$f":"IF($A43<>\"\",INDIRECT(\"'\"&$A43&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A43<>\"\",INDIRECT(\"'\"&$A43&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A43<>\"\",INDIRECT(\"'\"&$A43&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A43<>\"\",INDIRECT(\"'\"&$A43&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A43<>\"\",INDIRECT(\"'\"&$A43&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A43<>\"\",INDIRECT(\"'\"&$A43&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A43<>\"\",INDIRECT(\"'\"&$A43&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A43<>\"\",INDIRECT(\"'\"&$A43&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A43<>\"\",INDIRECT(\"'\"&$A43&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A43<>\"\",INDIRECT(\"'\"&$A43&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A43<>\"\",INDIRECT(\"'\"&$A43&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A43<>\"\",INDIRECT(\"'\"&$A43&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A44<>\"\",INDIRECT(\"'\"&A44&\"'!g2\"),\"\")","v":""},{"$f":"IF(A44<>\"\",INDIRECT(\"'\"&A44&\"'!c2\"),\"\")","v":""},{"$f":"IF($A44<>\"\",INDIRECT(\"'\"&$A44&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A44<>\"\",INDIRECT(\"'\"&$A44&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A44<>\"\",INDIRECT(\"'\"&$A44&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A44<>\"\",INDIRECT(\"'\"&$A44&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A44<>\"\",INDIRECT(\"'\"&$A44&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A44<>\"\",INDIRECT(\"'\"&$A44&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A44<>\"\",INDIRECT(\"'\"&$A44&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A44<>\"\",INDIRECT(\"'\"&$A44&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A44<>\"\",INDIRECT(\"'\"&$A44&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A44<>\"\",INDIRECT(\"'\"&$A44&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A44<>\"\",INDIRECT(\"'\"&$A44&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A44<>\"\",INDIRECT(\"'\"&$A44&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A45<>\"\",INDIRECT(\"'\"&A45&\"'!g2\"),\"\")","v":""},{"$f":"IF(A45<>\"\",INDIRECT(\"'\"&A45&\"'!c2\"),\"\")","v":""},{"$f":"IF($A45<>\"\",INDIRECT(\"'\"&$A45&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A45<>\"\",INDIRECT(\"'\"&$A45&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A45<>\"\",INDIRECT(\"'\"&$A45&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A45<>\"\",INDIRECT(\"'\"&$A45&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A45<>\"\",INDIRECT(\"'\"&$A45&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A45<>\"\",INDIRECT(\"'\"&$A45&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A45<>\"\",INDIRECT(\"'\"&$A45&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A45<>\"\",INDIRECT(\"'\"&$A45&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A45<>\"\",INDIRECT(\"'\"&$A45&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A45<>\"\",INDIRECT(\"'\"&$A45&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A45<>\"\",INDIRECT(\"'\"&$A45&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A45<>\"\",INDIRECT(\"'\"&$A45&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A46<>\"\",INDIRECT(\"'\"&A46&\"'!g2\"),\"\")","v":""},{"$f":"IF(A46<>\"\",INDIRECT(\"'\"&A46&\"'!c2\"),\"\")","v":""},{"$f":"IF($A46<>\"\",INDIRECT(\"'\"&$A46&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A46<>\"\",INDIRECT(\"'\"&$A46&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A46<>\"\",INDIRECT(\"'\"&$A46&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A46<>\"\",INDIRECT(\"'\"&$A46&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A46<>\"\",INDIRECT(\"'\"&$A46&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A46<>\"\",INDIRECT(\"'\"&$A46&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A46<>\"\",INDIRECT(\"'\"&$A46&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A46<>\"\",INDIRECT(\"'\"&$A46&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A46<>\"\",INDIRECT(\"'\"&$A46&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A46<>\"\",INDIRECT(\"'\"&$A46&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A46<>\"\",INDIRECT(\"'\"&$A46&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A46<>\"\",INDIRECT(\"'\"&$A46&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A47<>\"\",INDIRECT(\"'\"&A47&\"'!g2\"),\"\")","v":""},{"$f":"IF(A47<>\"\",INDIRECT(\"'\"&A47&\"'!c2\"),\"\")","v":""},{"$f":"IF($A47<>\"\",INDIRECT(\"'\"&$A47&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A47<>\"\",INDIRECT(\"'\"&$A47&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A47<>\"\",INDIRECT(\"'\"&$A47&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A47<>\"\",INDIRECT(\"'\"&$A47&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A47<>\"\",INDIRECT(\"'\"&$A47&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A47<>\"\",INDIRECT(\"'\"&$A47&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A47<>\"\",INDIRECT(\"'\"&$A47&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A47<>\"\",INDIRECT(\"'\"&$A47&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A47<>\"\",INDIRECT(\"'\"&$A47&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A47<>\"\",INDIRECT(\"'\"&$A47&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A47<>\"\",INDIRECT(\"'\"&$A47&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A47<>\"\",INDIRECT(\"'\"&$A47&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A48<>\"\",INDIRECT(\"'\"&A48&\"'!g2\"),\"\")","v":""},{"$f":"IF(A48<>\"\",INDIRECT(\"'\"&A48&\"'!c2\"),\"\")","v":""},{"$f":"IF($A48<>\"\",INDIRECT(\"'\"&$A48&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A48<>\"\",INDIRECT(\"'\"&$A48&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A48<>\"\",INDIRECT(\"'\"&$A48&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A48<>\"\",INDIRECT(\"'\"&$A48&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A48<>\"\",INDIRECT(\"'\"&$A48&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A48<>\"\",INDIRECT(\"'\"&$A48&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A48<>\"\",INDIRECT(\"'\"&$A48&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A48<>\"\",INDIRECT(\"'\"&$A48&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A48<>\"\",INDIRECT(\"'\"&$A48&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A48<>\"\",INDIRECT(\"'\"&$A48&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A48<>\"\",INDIRECT(\"'\"&$A48&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A48<>\"\",INDIRECT(\"'\"&$A48&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A49<>\"\",INDIRECT(\"'\"&A49&\"'!g2\"),\"\")","v":""},{"$f":"IF(A49<>\"\",INDIRECT(\"'\"&A49&\"'!c2\"),\"\")","v":""},{"$f":"IF($A49<>\"\",INDIRECT(\"'\"&$A49&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A49<>\"\",INDIRECT(\"'\"&$A49&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A49<>\"\",INDIRECT(\"'\"&$A49&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A49<>\"\",INDIRECT(\"'\"&$A49&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A49<>\"\",INDIRECT(\"'\"&$A49&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A49<>\"\",INDIRECT(\"'\"&$A49&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A49<>\"\",INDIRECT(\"'\"&$A49&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A49<>\"\",INDIRECT(\"'\"&$A49&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A49<>\"\",INDIRECT(\"'\"&$A49&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A49<>\"\",INDIRECT(\"'\"&$A49&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A49<>\"\",INDIRECT(\"'\"&$A49&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A49<>\"\",INDIRECT(\"'\"&$A49&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A50<>\"\",INDIRECT(\"'\"&A50&\"'!g2\"),\"\")","v":""},{"$f":"IF(A50<>\"\",INDIRECT(\"'\"&A50&\"'!c2\"),\"\")","v":""},{"$f":"IF($A50<>\"\",INDIRECT(\"'\"&$A50&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A50<>\"\",INDIRECT(\"'\"&$A50&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A50<>\"\",INDIRECT(\"'\"&$A50&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A50<>\"\",INDIRECT(\"'\"&$A50&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A50<>\"\",INDIRECT(\"'\"&$A50&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A50<>\"\",INDIRECT(\"'\"&$A50&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A50<>\"\",INDIRECT(\"'\"&$A50&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A50<>\"\",INDIRECT(\"'\"&$A50&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A50<>\"\",INDIRECT(\"'\"&$A50&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A50<>\"\",INDIRECT(\"'\"&$A50&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A50<>\"\",INDIRECT(\"'\"&$A50&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A50<>\"\",INDIRECT(\"'\"&$A50&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A51<>\"\",INDIRECT(\"'\"&A51&\"'!g2\"),\"\")","v":""},{"$f":"IF(A51<>\"\",INDIRECT(\"'\"&A51&\"'!c2\"),\"\")","v":""},{"$f":"IF($A51<>\"\",INDIRECT(\"'\"&$A51&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A51<>\"\",INDIRECT(\"'\"&$A51&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A51<>\"\",INDIRECT(\"'\"&$A51&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A51<>\"\",INDIRECT(\"'\"&$A51&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A51<>\"\",INDIRECT(\"'\"&$A51&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A51<>\"\",INDIRECT(\"'\"&$A51&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A51<>\"\",INDIRECT(\"'\"&$A51&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A51<>\"\",INDIRECT(\"'\"&$A51&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A51<>\"\",INDIRECT(\"'\"&$A51&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A51<>\"\",INDIRECT(\"'\"&$A51&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A51<>\"\",INDIRECT(\"'\"&$A51&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A51<>\"\",INDIRECT(\"'\"&$A51&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A52<>\"\",INDIRECT(\"'\"&A52&\"'!g2\"),\"\")","v":""},{"$f":"IF(A52<>\"\",INDIRECT(\"'\"&A52&\"'!c2\"),\"\")","v":""},{"$f":"IF($A52<>\"\",INDIRECT(\"'\"&$A52&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A52<>\"\",INDIRECT(\"'\"&$A52&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A52<>\"\",INDIRECT(\"'\"&$A52&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A52<>\"\",INDIRECT(\"'\"&$A52&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A52<>\"\",INDIRECT(\"'\"&$A52&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A52<>\"\",INDIRECT(\"'\"&$A52&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A52<>\"\",INDIRECT(\"'\"&$A52&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A52<>\"\",INDIRECT(\"'\"&$A52&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A52<>\"\",INDIRECT(\"'\"&$A52&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A52<>\"\",INDIRECT(\"'\"&$A52&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A52<>\"\",INDIRECT(\"'\"&$A52&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A52<>\"\",INDIRECT(\"'\"&$A52&\"'!$j$16\"),\"\")","v":""}]
[null,null,{"$f":"IF(A53<>\"\",INDIRECT(\"'\"&A53&\"'!g2\"),\"\")","v":""},{"$f":"IF(A53<>\"\",INDIRECT(\"'\"&A53&\"'!c2\"),\"\")","v":""},{"$f":"IF($A53<>\"\",INDIRECT(\"'\"&$A53&\"'!$B$5\"),\"\")","v":""},{"$f":"IF($A53<>\"\",INDIRECT(\"'\"&$A53&\"'!$B$6\"),\"\")","v":""},{"$f":"IF($A53<>\"\",INDIRECT(\"'\"&$A53&\"'!$B$7\"),\"\")","v":""},{"$f":"IF($A53<>\"\",INDIRECT(\"'\"&$A53&\"'!$B$8\"),\"\")","v":""},{"$f":"IF($A53<>\"\",INDIRECT(\"'\"&$A53&\"'!$B$9\"),\"\")","v":""},{"$f":"IF($A53<>\"\",INDIRECT(\"'\"&$A53&\"'!$B$10\"),\"\")","v":""},{"$f":"IF($A53<>\"\",INDIRECT(\"'\"&$A53&\"'!$B$11\"),\"\")","v":""},{"$f":"IF($A53<>\"\",INDIRECT(\"'\"&$A53&\"'!$B$12\"),\"\")","v":""},{"$f":"IF($A53<>\"\",INDIRECT(\"'\"&$A53&\"'!$B$13\"),\"\")","v":""},{"$f":"IF($A53<>\"\",INDIRECT(\"'\"&$A53&\"'!$g$14\"),\"\")","v":""},{"$f":"IF($A53<>\"\",INDIRECT(\"'\"&$A53&\"'!$h$14\"),\"\")","v":""},{"$f":"IF($A53<>\"\",INDIRECT(\"'\"&$A53&\"'!$j$16\"),\"\")","v":""}]
[]
[null,null,null,"Total Y:",{"$f":"COUNTIFS(E$3:E$53,\"Y\")","v":0},{"$f":"COUNTIFS(F$3:F$53,\"Y\")","v":0},0,0,0,0,0,0,0]
[null,null,null,"Total N:",{"$f":"COUNTIFS(E$3:E$53,\"N\")","v":5},{"$f":"COUNTIFS(F$3:F$53,\"N\")","v":5},5,5,5,5,5,5,5]

{"sheet":"Risk Rating","index":5,"n_rows":55,"n_cols":29,"rows_kept":55,"cut":false,"hidden":false,"merged":[[2,28,15,31],[0,6,0,25],[54,6,56,25]]}
["#","Component","Likelihood","Consequence","Weighted Impact Score",null,{"$f":"company_name&\" - \"&system_name","v":"Trial Company - Trial System"},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Component Summary Sheet"]
[1,{"$f":"'Component Summary Sheet'!A3","v":"Comp 1"},{"$f":"'Component Summary Sheet'!N3","v":0},{"$f":"'Component Summary Sheet'!O3","v":0},{"$f":"'Component Summary Sheet'!P3","v":0}]
[2,{"$f":"'Component Summary Sheet'!A4","v":"Comp 2"},{"$f":"'Component Summary Sheet'!N4","v":0},{"$f":"'Component Summary Sheet'!O4","v":0},{"$f":"'Component Summary Sheet'!P4","v":0},null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"Correcting Chart Data Labels in Excel:  After entering your L/C scores if the data labels appear as empty they must be reset in Excel.  Follow this procedure to make your data labels appear properly.\n1. Right Click on the data label box\n2. Select \"Format Data Label\"\n3. In the right hand drop down box select the far right \"Label Options\" Category\n4. Uncheck the box \"Value From Cells\"\n5. Re-Check the box \"Value From Cells\"\n6. Click \"Reset Label Text\"\n7. Close the EDIT drop down box"]
[3,{"$f":"'Component Summary Sheet'!A5","v":"Comp 3"},{"$f":"'Component Summary Sheet'!N5","v":0},{"$f":"'Component Summary Sheet'!O5","v":0},{"$f":"'Component Summary Sheet'!P5","v":0}]
[4,{"$f":"'Component Summary Sheet'!A6","v":"Comp 4"},{"$f":"'Component Summary Sheet'!N6","v":0},{"$f":"'Component Summary Sheet'!O6","v":0},{"$f":"'Component Summary Sheet'!P6","v":0}]
[5,{"$f":"'Component Summary Sheet'!A7","v":"Comp 5"},{"$f":"'Component Summary Sheet'!N7","v":0},{"$f":"'Component Summary Sheet'!O7","v":0},{"$f":"'Component Summary Sheet'!P7","v":0}]
[6]
[7]
[8]
[9]
[10]
[11]
[12]
[13]
[14]
[15]
[16]
[17]
[18]
[19]
[20]
[21]
[22]
[23]
[24]
[25]
[26]
[27]
[28]
[29]
[30]
[31]
[32]
[33]
[34]
[35]
[36]
[37]
[38]
[39]
[40]
[41]
[42]
[43]
[44]
[45]
[46]
[47]
[48]
[49]
[50]
[51]
[]
[]
[null,null,null,null,null,null,{"$f":"distro_statement","v":"DISTRIBUTION STATEMENT: No Distribution Statement Determined. "}]

{"sheet":"Comp 1","index":6,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[[1,16,1,20],[2,8,3,8],[2,9,3,9],[33,6,33,7],[31,8,31,9],[32,8,32,9],[33,8,33,9],[28,8,28,9],[29,6,29,7],[13,16,14,16],[13,17,14,17],[13,19,14,19],[13,20,14,20],[27,4,28,4],[27,5,27,9],[28,6,28,7],[31,6,31,7],[32,6,32,7],[12,3,12,5],[13,3,13,5],[14,3,14,5],[13,8,14,9],[2,3,2,5],[3,3,3,5],[4,3,4,5],[5,3,5,5],[26,3,26,9],[27,3,28,3],[0,0,0,1],[1,0,1,1],[0,6,0,9],[1,6,1,9],[0,3,0,5],[1,3,1,5],[2,0,2,2],[13,0,13,1],[15,8,16,8],[15,3,15,7],[16,3,16,7],[13,6,14,6],[13,7,14,7],[11,3,11,5],[6,3,6,5],[2,11,9,14],[42,0,43,9],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[30,6,30,7],[29,8,29,9],[30,8,30,9],[18,3,18,5],[15,9,16,9],[18,7,19,7],[21,7,22,7],[34,3,34,9],[35,3,36,9]]}
["Component Name",null,"Component Supplier","OEM Point of Contact",null,null,"Component Engineer"]
["Name",null,"Supplier","POC",null,null,"Engineer",null,null,null,null,null,null,null,null,null,"This section is for charting and error checking - Do not alter"]
["Response to MRL Questions1",null,null,"Risk Statement",null,null,"Likelihood2","Consequence2","Impact\nScore","Weighted\nImpact\nScore",null,"Correcting Chart Data Labels in Excel:  After entering your L/C scores if the data labels appear as empty they must be reset in Excel.  Follow this procedure to make your data labels appear properly.\n1. Right Click on the data label box\n2. Select \"Format Data Label\"\n3. In the right hand drop down box select the far right \"Label Options\" Category\n4. Uncheck the box \"Value From Cells\"\n5. Re-Check the box \"Value From Cells\"\n6. Confirm selection area is =$A$5:$A$13\n7. Click OK\n8. Click \"Reset Label Text\"\n9. Close the EDIT drop down box",null,null,null,null,"Likelihood2","Consequence2",null,"Likelihood2","Consequence2"]
["Category/Question","y/n","Explanation for Response"," (derived from Explanation for Response)",null,null,"(of occurrence)","(to system)",null,null,null,null,null,null,null,null,"(of occurrence)","(to system)",null,"(of occurrence)","(to system)"]
["Materials","n",null,null,null,null,null,null,{"$f":"IF(AND(B5=\"y\",G5>0,G5<6,H5>0,H5<6),G5*H5,\"\")","v":""},{"$f":"IF(I5<>\"\",I5*9*('System Information'!B28/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B5=\"y\",G5>0,G5<6),G5,FALSE)","v":false},{"$f":"IF(AND(B5=\"y\",H5>0,H5<6),H5,FALSE)","v":false},null,{"$f":"IF(AND(Q5<>\"\",TRUE),Q5,0)","v":false},{"$f":"IF(R5<>\"\",R5,0)","v":false}]
["Cost","n",null,null,null,null,null,null,{"$f":"IF(AND(B6=\"y\",G6>0,G6<6,H6>0,H6<6),G6*H6,\"\")","v":""},{"$f":"IF(I6<>\"\",I6*9*('System Information'!B29/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B6=\"y\",G6>0,G6<6),G6,FALSE)","v":false},{"$f":"IF(AND(B6=\"y\",H6>0,H6<6),H6,FALSE)","v":false},null,{"$f":"IF(Q6<>\"\",Q6,0)","v":false},{"$f":"IF(R6<>\"\",R6,0)","v":false}]
["Design","n",null,null,null,null,null,null,"",{"$f":"IF(I7<>\"\",I7*9*('System Information'!B30/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Manufacturing Process","n",null,null,null,null,null,null,"",{"$f":"IF(I8<>\"\",I8*9*('System Information'!B31/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Quality","n",null,null,null,null,null,null,"",{"$f":"IF(I9<>\"\",I9*9*('System Information'!B32/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Schedule","n",null,null,null,null,null,null,"",{"$f":"IF(I10<>\"\",I10*9*('System Information'!B33/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Facilities","n",null,null,null,null,null,null,"",{"$f":"IF(I11<>\"\",I11*9*('System Information'!B34/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Supply Chain Management","n",null,null,null,null,null,null,"",{"$f":"IF(I12<>\"\",I12*9*('System Information'!B35/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Industrial Base","n",null,null,null,null,null,null,"",{"$f":"IF(I13<>\"\",I13*9*('System Information'!B36/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
[null,null,null,"Weighted Likelihood and Consequence:",null,null,{"$f":"IF(T14>0,T14,0)","v":0},{"$f":"IF(U14>0,U14,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(T5:T13)<>0,SUMSQ(T5:T13)/SUM(T5:T13),0)","v":0},{"$f":"IF(SUM(U5:U13)<>0,SUMSQ(U5:U13)/SUM(U5:U13),0)","v":0}]
[null,null,null,"(Used for Component/Supplier Risk Rating graphic)"]
[null,null,null,"Sum of Impact Scores:",null,null,null,null,{"$f":"IF(SUM(I5:I13)>0,SUM(I5:I13),0)","v":0},{"$f":"IF(SUM(J5:J13)>0,SUM(J5:J13),0)","v":0}]
[null,null,null,"(Used to rank potential resources required)  "]
[]
[null,null,null,{"$f":"'Category Guidance'!B2","v":"Category Guidance: Likelihood of Occurrence"},null,null,null,"Risk Rating"]
[null,null,null,{"$f":"'Category Guidance'!B3","v":"Level"},{"$f":"'Category Guidance'!C3","v":"Likelihood"},{"$f":"'Category Guidance'!D3","v":"Probability of Occurrence"}]
[null,null,null,{"$f":"'Category Guidance'!B4","v":1},{"$f":"'Category Guidance'!C4","v":"Not Likely"},{"$f":"'Category Guidance'!D4","v":"~10%"}]
[null,null,null,{"$f":"'Category Guidance'!B5","v":2},{"$f":"'Category Guidance'!C5","v":"Low Likelihood"},{"$f":"'Category Guidance'!D5","v":"~30%"},null,"Component Summary Sheet"]
[null,null,null,{"$f":"'Category Guidance'!B6","v":3},{"$f":"'Category Guidance'!C6","v":"Likely"},{"$f":"'Category Guidance'!D6","v":"~50%"}]
[null,null,null,{"$f":"'Category Guidance'!B7","v":4},{"$f":"'Category Guidance'!C7","v":"Highly Likely"},{"$f":"'Category Guidance'!D7","v":"~70%"},null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"'Category Guidance'!B8","v":5},{"$f":"'Category Guidance'!C8","v":"Near Certainty"},{"$f":"'Category Guidance'!D8","v":"~90%"},null,"Hot Links "]
[]
[null,null,null,{"$f":"'Category Guidance'!E10","v":"Category Guidance: Consequence (System Impact)"}]
[null,null,null,{"$f":"'Category Guidance'!E11","v":"Level"},"Consequence",{"$f":"'Category Guidance'!G11","v":"System Impact"}]
[null,null,null,null,null,{"$f":"'Category Guidance'!G12","v":"Technical Performance"},{"$f":"'Category Guidance'!H12","v":"Schedule"},null,{"$f":"'Category Guidance'!I12","v":"Cost"}]
[null,null,null,{"$f":"'Category Guidance'!E13","v":1},{"$f":"'Category Guidance'!F13","v":"Minimal"},{"$f":"'Category Guidance'!G13","v":"Minimal or no consequence to technical performance"},{"$f":"'Category Guidance'!H13","v":"Minimal or no impact"},null,{"$f":"'Category Guidance'!I13","v":"Minimal or no impact"}]
[null,null,null,{"$f":"'Category Guidance'!E14","v":2},{"$f":"'Category Guidance'!F14","v":"Minor"},{"$f":"'Category Guidance'!G14","v":"Minor reduction in technical performance or supportability, can be tolerated with little or no impact on program"},{"$f":"'Category Guidance'!H14","v":"Able to meet key dates. \nSlip < 6 month(s)"},null,{"$f":"'Category Guidance'!I14","v":"Budget increase or unit production cost increases.\n(< 1% of Budget)"}]
[null,null,null,{"$f":"'Category Guidance'!E15","v":3},{"$f":"'Category Guidance'!F15","v":"Moderate"},{"$f":"'Category Guidance'!G15","v":"Moderate reduction in technical performance or supportability with limited impact on program objectives"},{"$f":"'Category Guidance'!H15","v":"Minor schedule slip. Able to meet key milestones with no schedule float.\nSlip < 6 month(s). Sub-system slip > 12 month(s) plus available float."},null,{"$f":"'Category Guidance'!I15","v":"Budget increase or unit production cost increases.\n(< 5% of Budget)"}]
[null,null,null,{"$f":"'Category Guidance'!E16","v":4},{"$f":"'Category Guidance'!F16","v":"Significant"},{"$f":"'Category Guidance'!G16","v":"Significant degradation in technical performance or major shortfall in supportability; may jeopardize program success"},{"$f":"'Category Guidance'!H16","v":"Program critical path affected.\nSlip < 12 months"},null,{"$f":"'Category Guidance'!I16","v":"Budget increase or unit production cost increases.\n(< 10% of Budget)"}]
["Action Taken with this Supplier","Date","Comments for Action Taken",{"$f":"'Category Guidance'!E17","v":5},{"$f":"'Category Guidance'!F17","v":"Severe"},{"$f":"'Category Guidance'!G17","v":"Severe degradation in technical performance; Cannot meet KPP or key technical/supportability threshold; will jeopardize program success"},{"$f":"'Category Guidance'!H17","v":"Cannot meet key program milestones. \nSlip > 12months"},null,{"$f":"'Category Guidance'!I17","v":"Exceeds APB threshold\n(> 10% of Budget)"}]
["No Action",{"$f":"rev_date","v":"2020-07-15"},"Initial Assessment","1 - Reference - DOD MRL Deskbook (pp 32) - http://www.dodmrl.com/MRL_Deskbook_2018.pdf"]
[null,null,null,"2 - Reference - Risk Management Guide for DOD Acquisition - Sixth Edition (Version 1.0)\nhttps://www.acq.osd.mil/damir/documents/DAES_2006_RISK_GUIDE.pdf"]
[]
[]
[]
[]
[]
[]
[{"$f":"distro_statement","v":"DISTRIBUTION STATEMENT: No Distribution Statement Determined. "}]

{"sheet":"Comp 2","index":7,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,0,43,9],[32,6,32,7],[32,8,32,9],[33,6,33,7],[33,8,33,9],[34,3,34,9],[35,3,36,9],[29,6,29,7],[29,8,29,9],[30,6,30,7],[30,8,30,9],[31,6,31,7],[31,8,31,9],[18,3,18,5],[18,7,19,7],[21,7,22,7],[26,3,26,9],[27,3,28,3],[27,4,28,4],[27,5,27,9],[28,6,28,7],[28,8,28,9],[13,17,14,17],[13,19,14,19],[13,20,14,20],[14,3,14,5],[15,3,15,7],[15,8,16,8],[15,9,16,9],[16,3,16,7],[13,16,14,16],[13,0,13,1],[13,3,13,5],[13,6,14,6],[13,7,14,7],[13,8,14,9],[12,3,12,5],[1,16,1,20],[2,0,2,2],[2,3,2,5],[2,8,3,8],[2,9,3,9],[2,11,9,14],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[0,0,0,1],[0,3,0,5],[0,6,0,9],[1,0,1,1],[1,3,1,5],[1,6,1,9]]}
["Component Name",null,"Component Supplier","OEM Point of Contact",null,null,"Component Engineer"]
["Name",null,"Supplier","POC",null,null,"Engineer",null,null,null,null,null,null,null,null,null,"This section is for charting and error checking - Do not alter"]
["Response to MRL Questions1",null,null,"Risk Statement",null,null,"Likelihood2","Consequence2","Impact\nScore","Weighted\nImpact\nScore",null,"Correcting Chart Data Labels in Excel:  After entering your L/C scores if the data labels appear as empty they must be reset in Excel.  Follow this procedure to make your data labels appear properly.\n1. Right Click on the data label box\n2. Select \"Format Data Label\"\n3. In the right hand drop down box select the far right \"Label Options\" Category\n4. Uncheck the box \"Value From Cells\"\n5. Re-Check the box \"Value From Cells\"\n6. Confirm selection area is =$A$5:$A$13\n7. Click OK\n8. Click \"Reset Label Text\"\n9. Close the EDIT drop down box",null,null,null,null,"Likelihood2","Consequence2",null,"Likelihood2","Consequence2"]
["Category/Question","y/n","Explanation for Response"," (derived from Explanation for Response)",null,null,"(of occurrence)","(to system)",null,null,null,null,null,null,null,null,"(of occurrence)","(to system)",null,"(of occurrence)","(to system)"]
["Materials","n",null,null,null,null,null,null,{"$f":"IF(AND(B5=\"y\",G5>0,G5<6,H5>0,H5<6),G5*H5,\"\")","v":""},{"$f":"IF(I5<>\"\",I5*9*('System Information'!B28/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B5=\"y\",G5>0,G5<6),G5,FALSE)","v":false},{"$f":"IF(AND(B5=\"y\",H5>0,H5<6),H5,FALSE)","v":false},null,{"$f":"IF(AND(Q5<>\"\",TRUE),Q5,0)","v":false},{"$f":"IF(R5<>\"\",R5,0)","v":false}]
["Cost","n",null,null,null,null,null,null,{"$f":"IF(AND(B6=\"y\",G6>0,G6<6,H6>0,H6<6),G6*H6,\"\")","v":""},{"$f":"IF(I6<>\"\",I6*9*('System Information'!B29/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B6=\"y\",G6>0,G6<6),G6,FALSE)","v":false},{"$f":"IF(AND(B6=\"y\",H6>0,H6<6),H6,FALSE)","v":false},null,{"$f":"IF(Q6<>\"\",Q6,0)","v":false},false]
["Design","n",null,null,null,null,null,null,"",{"$f":"IF(I7<>\"\",I7*9*('System Information'!B30/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Manufacturing Process","n",null,null,null,null,null,null,"",{"$f":"IF(I8<>\"\",I8*9*('System Information'!B31/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Quality","n",null,null,null,null,null,null,"",{"$f":"IF(I9<>\"\",I9*9*('System Information'!B32/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Schedule","n",null,null,null,null,null,null,"",{"$f":"IF(I10<>\"\",I10*9*('System Information'!B33/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Facilities","n",null,null,null,null,null,null,"",{"$f":"IF(I11<>\"\",I11*9*('System Information'!B34/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Supply Chain Management","n",null,null,null,null,null,null,"",{"$f":"IF(I12<>\"\",I12*9*('System Information'!B35/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Industrial Base","n",null,null,null,null,null,null,"",{"$f":"IF(I13<>\"\",I13*9*('System Information'!B36/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
[null,null,null,"Weighted Likelihood and Consequence:",null,null,{"$f":"IF(T14>0,T14,0)","v":0},{"$f":"IF(U14>0,U14,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(T5:T13)<>0,SUMSQ(T5:T13)/SUM(T5:T13),0)","v":0},{"$f":"IF(SUM(U5:U13)<>0,SUMSQ(U5:U13)/SUM(U5:U13),0)","v":0}]
[null,null,null,"(Used for Component/Supplier Risk Rating graphic)"]
[null,null,null,"Sum of Impact Scores:",null,null,null,null,{"$f":"IF(SUM(I5:I13)>0,SUM(I5:I13),0)","v":0},{"$f":"IF(SUM(J5:J13)>0,SUM(J5:J13),0)","v":0}]
[null,null,null,"(Used to rank potential resources required)  "]
[]
[null,null,null,{"$f":"'Category Guidance'!B2","v":"Category Guidance: Likelihood of Occurrence"},null,null,null,"Risk Rating"]
[null,null,null,{"$f":"'Category Guidance'!B3","v":"Level"},{"$f":"'Category Guidance'!C3","v":"Likelihood"},{"$f":"'Category Guidance'!D3","v":"Probability of Occurrence"}]
[null,null,null,{"$f":"'Category Guidance'!B4","v":1},{"$f":"'Category Guidance'!C4","v":"Not Likely"},{"$f":"'Category Guidance'!D4","v":"~10%"}]
[null,null,null,{"$f":"'Category Guidance'!B5","v":2},{"$f":"'Category Guidance'!C5","v":"Low Likelihood"},{"$f":"'Category Guidance'!D5","v":"~30%"},null,"Component Summary Sheet"]
[null,null,null,{"$f":"'Category Guidance'!B6","v":3},{"$f":"'Category Guidance'!C6","v":"Likely"},{"$f":"'Category Guidance'!D6","v":"~50%"}]
[null,null,null,{"$f":"'Category Guidance'!B7","v":4},{"$f":"'Category Guidance'!C7","v":"Highly Likely"},{"$f":"'Category Guidance'!D7","v":"~70%"},null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"'Category Guidance'!B8","v":5},{"$f":"'Category Guidance'!C8","v":"Near Certainty"},{"$f":"'Category Guidance'!D8","v":"~90%"},null,"Hot Links "]
[]
[null,null,null,{"$f":"'Category Guidance'!E10","v":"Category Guidance: Consequence (System Impact)"}]
[null,null,null,{"$f":"'Category Guidance'!E11","v":"Level"},"Consequence",{"$f":"'Category Guidance'!G11","v":"System Impact"}]
[null,null,null,null,null,{"$f":"'Category Guidance'!G12","v":"Technical Performance"},{"$f":"'Category Guidance'!H12","v":"Schedule"},null,{"$f":"'Category Guidance'!I12","v":"Cost"}]
[null,null,null,{"$f":"'Category Guidance'!E13","v":1},{"$f":"'Category Guidance'!F13","v":"Minimal"},{"$f":"'Category Guidance'!G13","v":"Minimal or no consequence to technical performance"},{"$f":"'Category Guidance'!H13","v":"Minimal or no impact"},null,{"$f":"'Category Guidance'!I13","v":"Minimal or no impact"}]
[null,null,null,{"$f":"'Category Guidance'!E14","v":2},{"$f":"'Category Guidance'!F14","v":"Minor"},{"$f":"'Category Guidance'!G14","v":"Minor reduction in technical performance or supportability, can be tolerated with little or no impact on program"},{"$f":"'Category Guidance'!H14","v":"Able to meet key dates. \nSlip < 6 month(s)"},null,{"$f":"'Category Guidance'!I14","v":"Budget increase or unit production cost increases.\n(< 1% of Budget)"}]
[null,null,null,{"$f":"'Category Guidance'!E15","v":3},{"$f":"'Category Guidance'!F15","v":"Moderate"},{"$f":"'Category Guidance'!G15","v":"Moderate reduction in technical performance or supportability with limited impact on program objectives"},{"$f":"'Category Guidance'!H15","v":"Minor schedule slip. Able to meet key milestones with no schedule float.\nSlip < 6 month(s). Sub-system slip > 12 month(s) plus available float."},null,{"$f":"'Category Guidance'!I15","v":"Budget increase or unit production cost increases.\n(< 5% of Budget)"}]
[null,null,null,{"$f":"'Category Guidance'!E16","v":4},{"$f":"'Category Guidance'!F16","v":"Significant"},{"$f":"'Category Guidance'!G16","v":"Significant degradation in technical performance or major shortfall in supportability; may jeopardize program success"},{"$f":"'Category Guidance'!H16","v":"Program critical path affected.\nSlip < 12 months"},null,{"$f":"'Category Guidance'!I16","v":"Budget increase or unit production cost increases.\n(< 10% of Budget)"}]
["Action Taken with this Supplier","Date","Comments for Action Taken",{"$f":"'Category Guidance'!E17","v":5},{"$f":"'Category Guidance'!F17","v":"Severe"},{"$f":"'Category Guidance'!G17","v":"Severe degradation in technical performance; Cannot meet KPP or key technical/supportability threshold; will jeopardize program success"},{"$f":"'Category Guidance'!H17","v":"Cannot meet key program milestones. \nSlip > 12months"},null,{"$f":"'Category Guidance'!I17","v":"Exceeds APB threshold\n(> 10% of Budget)"}]
["No Action",{"$f":"rev_date","v":"2020-07-15"},"Initial Assessment","1 - Reference - DOD MRL Deskbook (pp 32) - http://www.dodmrl.com/MRL_Deskbook_2018.pdf"]
[null,null,null,"2 - Reference - Risk Management Guide for DOD Acquisition - Sixth Edition (Version 1.0)\nhttps://www.acq.osd.mil/damir/documents/DAES_2006_RISK_GUIDE.pdf"]
[]
[]
[]
[]
[]
[]
[{"$f":"distro_statement","v":"DISTRIBUTION STATEMENT: No Distribution Statement Determined. "}]

{"sheet":"Comp 3","index":8,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,0,43,9],[32,6,32,7],[32,8,32,9],[33,6,33,7],[33,8,33,9],[34,3,34,9],[35,3,36,9],[29,6,29,7],[29,8,29,9],[30,6,30,7],[30,8,30,9],[31,6,31,7],[31,8,31,9],[18,3,18,5],[18,7,19,7],[21,7,22,7],[26,3,26,9],[27,3,28,3],[27,4,28,4],[27,5,27,9],[28,6,28,7],[28,8,28,9],[13,17,14,17],[13,19,14,19],[13,20,14,20],[14,3,14,5],[15,3,15,7],[15,8,16,8],[15,9,16,9],[16,3,16,7],[13,16,14,16],[13,0,13,1],[13,3,13,5],[13,6,14,6],[13,7,14,7],[13,8,14,9],[12,3,12,5],[1,16,1,20],[2,0,2,2],[2,3,2,5],[2,8,3,8],[2,9,3,9],[2,11,9,14],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[0,0,0,1],[0,3,0,5],[0,6,0,9],[1,0,1,1],[1,3,1,5],[1,6,1,9]]}
["Component Name",null,"Component Supplier","OEM Point of Contact",null,null,"Component Engineer"]
["Name",null,"Supplier","POC",null,null,"Engineer",null,null,null,null,null,null,null,null,null,"This section is for charting and error checking - Do not alter"]
["Response to MRL Questions1",null,null,"Risk Statement",null,null,"Likelihood2","Consequence2","Impact\nScore","Weighted\nImpact\nScore",null,"Correcting Chart Data Labels in Excel:  After entering your L/C scores if the data labels appear as empty they must be reset in Excel.  Follow this procedure to make your data labels appear properly.\n1. Right Click on the data label box\n2. Select \"Format Data Label\"\n3. In the right hand drop down box select the far right \"Label Options\" Category\n4. Uncheck the box \"Value From Cells\"\n5. Re-Check the box \"Value From Cells\"\n6. Confirm selection area is =$A$5:$A$13\n7. Click OK\n8. Click \"Reset Label Text\"\n9. Close the EDIT drop down box",null,null,null,null,"Likelihood2","Consequence2",null,"Likelihood2","Consequence2"]
["Category/Question","y/n","Explanation for Response"," (derived from Explanation for Response)",null,null,"(of occurrence)","(to system)",null,null,null,null,null,null,null,null,"(of occurrence)","(to system)",null,"(of occurrence)","(to system)"]
["Materials","n",null,null,null,null,null,null,{"$f":"IF(AND(B5=\"y\",G5>0,G5<6,H5>0,H5<6),G5*H5,\"\")","v":""},{"$f":"IF(I5<>\"\",I5*9*('System Information'!B28/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B5=\"y\",G5>0,G5<6),G5,FALSE)","v":false},{"$f":"IF(AND(B5=\"y\",H5>0,H5<6),H5,FALSE)","v":false},null,{"$f":"IF(AND(Q5<>\"\",TRUE),Q5,0)","v":false},{"$f":"IF(R5<>\"\",R5,0)","v":false}]
["Cost","n",null,null,null,null,null,null,{"$f":"IF(AND(B6=\"y\",G6>0,G6<6,H6>0,H6<6),G6*H6,\"\")","v":""},{"$f":"IF(I6<>\"\",I6*9*('System Information'!B29/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B6=\"y\",G6>0,G6<6),G6,FALSE)","v":false},{"$f":"IF(AND(B6=\"y\",H6>0,H6<6),H6,FALSE)","v":false},null,{"$f":"IF(Q6<>\"\",Q6,0)","v":false},false]
["Design","n",null,null,null,null,null,null,"",{"$f":"IF(I7<>\"\",I7*9*('System Information'!B30/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Manufacturing Process","n",null,null,null,null,null,null,"",{"$f":"IF(I8<>\"\",I8*9*('System Information'!B31/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Quality","n",null,null,null,null,null,null,"",{"$f":"IF(I9<>\"\",I9*9*('System Information'!B32/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Schedule","n",null,null,null,null,null,null,"",{"$f":"IF(I10<>\"\",I10*9*('System Information'!B33/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Facilities","n",null,null,null,null,null,null,"",{"$f":"IF(I11<>\"\",I11*9*('System Information'!B34/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Supply Chain Management","n",null,null,null,null,null,null,"",{"$f":"IF(I12<>\"\",I12*9*('System Information'!B35/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Industrial Base","n",null,null,null,null,null,null,"",{"$f":"IF(I13<>\"\",I13*9*('System Information'!B36/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
[null,null,null,"Weighted Likelihood and Consequence:",null,null,{"$f":"IF(T14>0,T14,0)","v":0},{"$f":"IF(U14>0,U14,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(T5:T13)<>0,SUMSQ(T5:T13)/SUM(T5:T13),0)","v":0},{"$f":"IF(SUM(U5:U13)<>0,SUMSQ(U5:U13)/SUM(U5:U13),0)","v":0}]
[null,null,null,"(Used for Component/Supplier Risk Rating graphic)"]
[null,null,null,"Sum of Impact Scores:",null,null,null,null,{"$f":"IF(SUM(I5:I13)>0,SUM(I5:I13),0)","v":0},{"$f":"IF(SUM(J5:J13)>0,SUM(J5:J13),0)","v":0}]
[null,null,null,"(Used to rank potential resources required)  "]
[]
[null,null,null,{"$f":"'Category Guidance'!B2","v":"Category Guidance: Likelihood of Occurrence"},null,null,null,"Risk Rating"]
[null,null,null,{"$f":"'Category Guidance'!B3","v":"Level"},{"$f":"'Category Guidance'!C3","v":"Likelihood"},{"$f":"'Category Guidance'!D3","v":"Probability of Occurrence"}]
[null,null,null,{"$f":"'Category Guidance'!B4","v":1},{"$f":"'Category Guidance'!C4","v":"Not Likely"},{"$f":"'Category Guidance'!D4","v":"~10%"}]
[null,null,null,{"$f":"'Category Guidance'!B5","v":2},{"$f":"'Category Guidance'!C5","v":"Low Likelihood"},{"$f":"'Category Guidance'!D5","v":"~30%"},null,"Component Summary Sheet"]
[null,null,null,{"$f":"'Category Guidance'!B6","v":3},{"$f":"'Category Guidance'!C6","v":"Likely"},{"$f":"'Category Guidance'!D6","v":"~50%"}]
[null,null,null,{"$f":"'Category Guidance'!B7","v":4},{"$f":"'Category Guidance'!C7","v":"Highly Likely"},{"$f":"'Category Guidance'!D7","v":"~70%"},null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"'Category Guidance'!B8","v":5},{"$f":"'Category Guidance'!C8","v":"Near Certainty"},{"$f":"'Category Guidance'!D8","v":"~90%"},null,"Hot Links "]
[]
[null,null,null,{"$f":"'Category Guidance'!E10","v":"Category Guidance: Consequence (System Impact)"}]
[null,null,null,{"$f":"'Category Guidance'!E11","v":"Level"},"Consequence",{"$f":"'Category Guidance'!G11","v":"System Impact"}]
[null,null,null,null,null,{"$f":"'Category Guidance'!G12","v":"Technical Performance"},{"$f":"'Category Guidance'!H12","v":"Schedule"},null,{"$f":"'Category Guidance'!I12","v":"Cost"}]
[null,null,null,{"$f":"'Category Guidance'!E13","v":1},{"$f":"'Category Guidance'!F13","v":"Minimal"},{"$f":"'Category Guidance'!G13","v":"Minimal or no consequence to technical performance"},{"$f":"'Category Guidance'!H13","v":"Minimal or no impact"},null,{"$f":"'Category Guidance'!I13","v":"Minimal or no impact"}]
[null,null,null,{"$f":"'Category Guidance'!E14","v":2},{"$f":"'Category Guidance'!F14","v":"Minor"},{"$f":"'Category Guidance'!G14","v":"Minor reduction in technical performance or supportability, can be tolerated with little or no impact on program"},{"$f":"'Category Guidance'!H14","v":"Able to meet key dates. \nSlip < 6 month(s)"},null,{"$f":"'Category Guidance'!I14","v":"Budget increase or unit production cost increases.\n(< 1% of Budget)"}]
[null,null,null,{"$f":"'Category Guidance'!E15","v":3},{"$f":"'Category Guidance'!F15","v":"Moderate"},{"$f":"'Category Guidance'!G15","v":"Moderate reduction in technical performance or supportability with limited impact on program objectives"},{"$f":"'Category Guidance'!H15","v":"Minor schedule slip. Able to meet key milestones with no schedule float.\nSlip < 6 month(s). Sub-system slip > 12 month(s) plus available float."},null,{"$f":"'Category Guidance'!I15","v":"Budget increase or unit production cost increases.\n(< 5% of Budget)"}]
[null,null,null,{"$f":"'Category Guidance'!E16","v":4},{"$f":"'Category Guidance'!F16","v":"Significant"},{"$f":"'Category Guidance'!G16","v":"Significant degradation in technical performance or major shortfall in supportability; may jeopardize program success"},{"$f":"'Category Guidance'!H16","v":"Program critical path affected.\nSlip < 12 months"},null,{"$f":"'Category Guidance'!I16","v":"Budget increase or unit production cost increases.\n(< 10% of Budget)"}]
["Action Taken with this Supplier","Date","Comments for Action Taken",{"$f":"'Category Guidance'!E17","v":5},{"$f":"'Category Guidance'!F17","v":"Severe"},{"$f":"'Category Guidance'!G17","v":"Severe degradation in technical performance; Cannot meet KPP or key technical/supportability threshold; will jeopardize program success"},{"$f":"'Category Guidance'!H17","v":"Cannot meet key program milestones. \nSlip > 12months"},null,{"$f":"'Category Guidance'!I17","v":"Exceeds APB threshold\n(> 10% of Budget)"}]
["No Action",{"$f":"rev_date","v":"2020-07-15"},"Initial Assessment","1 - Reference - DOD MRL Deskbook (pp 32) - http://www.dodmrl.com/MRL_Deskbook_2018.pdf"]
[null,null,null,"2 - Reference - Risk Management Guide for DOD Acquisition - Sixth Edition (Version 1.0)\nhttps://www.acq.osd.mil/damir/documents/DAES_2006_RISK_GUIDE.pdf"]
[]
[]
[]
[]
[]
[]
[{"$f":"distro_statement","v":"DISTRIBUTION STATEMENT: No Distribution Statement Determined. "}]

{"sheet":"Comp 4","index":9,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,0,43,9],[32,6,32,7],[32,8,32,9],[33,6,33,7],[33,8,33,9],[34,3,34,9],[35,3,36,9],[29,6,29,7],[29,8,29,9],[30,6,30,7],[30,8,30,9],[31,6,31,7],[31,8,31,9],[18,3,18,5],[18,7,19,7],[21,7,22,7],[26,3,26,9],[27,3,28,3],[27,4,28,4],[27,5,27,9],[28,6,28,7],[28,8,28,9],[13,17,14,17],[13,19,14,19],[13,20,14,20],[14,3,14,5],[15,3,15,7],[15,8,16,8],[15,9,16,9],[16,3,16,7],[13,16,14,16],[13,0,13,1],[13,3,13,5],[13,6,14,6],[13,7,14,7],[13,8,14,9],[12,3,12,5],[1,16,1,20],[2,0,2,2],[2,3,2,5],[2,8,3,8],[2,9,3,9],[2,11,9,14],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[0,0,0,1],[0,3,0,5],[0,6,0,9],[1,0,1,1],[1,3,1,5],[1,6,1,9]]}
["Component Name",null,"Component Supplier","OEM Point of Contact",null,null,"Component Engineer"]
["Name",null,"Supplier","POC",null,null,"Engineer",null,null,null,null,null,null,null,null,null,"This section is for charting and error checking - Do not alter"]
["Response to MRL Questions1",null,null,"Risk Statement",null,null,"Likelihood2","Consequence2","Impact\nScore","Weighted\nImpact\nScore",null,"Correcting Chart Data Labels in Excel:  After entering your L/C scores if the data labels appear as empty they must be reset in Excel.  Follow this procedure to make your data labels appear properly.\n1. Right Click on the data label box\n2. Select \"Format Data Label\"\n3. In the right hand drop down box select the far right \"Label Options\" Category\n4. Uncheck the box \"Value From Cells\"\n5. Re-Check the box \"Value From Cells\"\n6. Confirm selection area is =$A$5:$A$13\n7. Click OK\n8. Click \"Reset Label Text\"\n9. Close the EDIT drop down box",null,null,null,null,"Likelihood2","Consequence2",null,"Likelihood2","Consequence2"]
["Category/Question","y/n","Explanation for Response"," (derived from Explanation for Response)",null,null,"(of occurrence)","(to system)",null,null,null,null,null,null,null,null,"(of occurrence)","(to system)",null,"(of occurrence)","(to system)"]
["Materials","n",null,null,null,null,null,null,{"$f":"IF(AND(B5=\"y\",G5>0,G5<6,H5>0,H5<6),G5*H5,\"\")","v":""},{"$f":"IF(I5<>\"\",I5*9*('System Information'!B28/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B5=\"y\",G5>0,G5<6),G5,FALSE)","v":false},{"$f":"IF(AND(B5=\"y\",H5>0,H5<6),H5,FALSE)","v":false},null,{"$f":"IF(AND(Q5<>\"\",TRUE),Q5,0)","v":false},{"$f":"IF(R5<>\"\",R5,0)","v":false}]
["Cost","n",null,null,null,null,null,null,{"$f":"IF(AND(B6=\"y\",G6>0,G6<6,H6>0,H6<6),G6*H6,\"\")","v":""},{"$f":"IF(I6<>\"\",I6*9*('System Information'!B29/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B6=\"y\",G6>0,G6<6),G6,FALSE)","v":false},{"$f":"IF(AND(B6=\"y\",H6>0,H6<6),H6,FALSE)","v":false},null,{"$f":"IF(Q6<>\"\",Q6,0)","v":false},false]
["Design","n",null,null,null,null,null,null,"",{"$f":"IF(I7<>\"\",I7*9*('System Information'!B30/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Manufacturing Process","n",null,null,null,null,null,null,"",{"$f":"IF(I8<>\"\",I8*9*('System Information'!B31/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Quality","n",null,null,null,null,null,null,"",{"$f":"IF(I9<>\"\",I9*9*('System Information'!B32/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Schedule","n",null,null,null,null,null,null,"",{"$f":"IF(I10<>\"\",I10*9*('System Information'!B33/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Facilities","n",null,null,null,null,null,null,"",{"$f":"IF(I11<>\"\",I11*9*('System Information'!B34/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Supply Chain Management","n",null,null,null,null,null,null,"",{"$f":"IF(I12<>\"\",I12*9*('System Information'!B35/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Industrial Base","n",null,null,null,null,null,null,"",{"$f":"IF(I13<>\"\",I13*9*('System Information'!B36/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
[null,null,null,"Weighted Likelihood and Consequence:",null,null,{"$f":"IF(T14>0,T14,0)","v":0},{"$f":"IF(U14>0,U14,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(T5:T13)<>0,SUMSQ(T5:T13)/SUM(T5:T13),0)","v":0},{"$f":"IF(SUM(U5:U13)<>0,SUMSQ(U5:U13)/SUM(U5:U13),0)","v":0}]
[null,null,null,"(Used for Component/Supplier Risk Rating graphic)"]
[null,null,null,"Sum of Impact Scores:",null,null,null,null,{"$f":"IF(SUM(I5:I13)>0,SUM(I5:I13),0)","v":0},{"$f":"IF(SUM(J5:J13)>0,SUM(J5:J13),0)","v":0}]
[null,null,null,"(Used to rank potential resources required)  "]
[]
[null,null,null,{"$f":"'Category Guidance'!B2","v":"Category Guidance: Likelihood of Occurrence"},null,null,null,"Risk Rating"]
[null,null,null,{"$f":"'Category Guidance'!B3","v":"Level"},{"$f":"'Category Guidance'!C3","v":"Likelihood"},{"$f":"'Category Guidance'!D3","v":"Probability of Occurrence"}]
[null,null,null,{"$f":"'Category Guidance'!B4","v":1},{"$f":"'Category Guidance'!C4","v":"Not Likely"},{"$f":"'Category Guidance'!D4","v":"~10%"}]
[null,null,null,{"$f":"'Category Guidance'!B5","v":2},{"$f":"'Category Guidance'!C5","v":"Low Likelihood"},{"$f":"'Category Guidance'!D5","v":"~30%"},null,"Component Summary Sheet"]
[null,null,null,{"$f":"'Category Guidance'!B6","v":3},{"$f":"'Category Guidance'!C6","v":"Likely"},{"$f":"'Category Guidance'!D6","v":"~50%"}]
[null,null,null,{"$f":"'Category Guidance'!B7","v":4},{"$f":"'Category Guidance'!C7","v":"Highly Likely"},{"$f":"'Category Guidance'!D7","v":"~70%"},null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"'Category Guidance'!B8","v":5},{"$f":"'Category Guidance'!C8","v":"Near Certainty"},{"$f":"'Category Guidance'!D8","v":"~90%"},null,"Hot Links "]
[]
[null,null,null,{"$f":"'Category Guidance'!E10","v":"Category Guidance: Consequence (System Impact)"}]
[null,null,null,{"$f":"'Category Guidance'!E11","v":"Level"},"Consequence",{"$f":"'Category Guidance'!G11","v":"System Impact"}]
[null,null,null,null,null,{"$f":"'Category Guidance'!G12","v":"Technical Performance"},{"$f":"'Category Guidance'!H12","v":"Schedule"},null,{"$f":"'Category Guidance'!I12","v":"Cost"}]
[null,null,null,{"$f":"'Category Guidance'!E13","v":1},{"$f":"'Category Guidance'!F13","v":"Minimal"},{"$f":"'Category Guidance'!G13","v":"Minimal or no consequence to technical performance"},{"$f":"'Category Guidance'!H13","v":"Minimal or no impact"},null,{"$f":"'Category Guidance'!I13","v":"Minimal or no impact"}]
[null,null,null,{"$f":"'Category Guidance'!E14","v":2},{"$f":"'Category Guidance'!F14","v":"Minor"},{"$f":"'Category Guidance'!G14","v":"Minor reduction in technical performance or supportability, can be tolerated with little or no impact on program"},{"$f":"'Category Guidance'!H14","v":"Able to meet key dates. \nSlip < 6 month(s)"},null,{"$f":"'Category Guidance'!I14","v":"Budget increase or unit production cost increases.\n(< 1% of Budget)"}]
[null,null,null,{"$f":"'Category Guidance'!E15","v":3},{"$f":"'Category Guidance'!F15","v":"Moderate"},{"$f":"'Category Guidance'!G15","v":"Moderate reduction in technical performance or supportability with limited impact on program objectives"},{"$f":"'Category Guidance'!H15","v":"Minor schedule slip. Able to meet key milestones with no schedule float.\nSlip < 6 month(s). Sub-system slip > 12 month(s) plus available float."},null,{"$f":"'Category Guidance'!I15","v":"Budget increase or unit production cost increases.\n(< 5% of Budget)"}]
[null,null,null,{"$f":"'Category Guidance'!E16","v":4},{"$f":"'Category Guidance'!F16","v":"Significant"},{"$f":"'Category Guidance'!G16","v":"Significant degradation in technical performance or major shortfall in supportability; may jeopardize program success"},{"$f":"'Category Guidance'!H16","v":"Program critical path affected.\nSlip < 12 months"},null,{"$f":"'Category Guidance'!I16","v":"Budget increase or unit production cost increases.\n(< 10% of Budget)"}]
["Action Taken with this Supplier","Date","Comments for Action Taken",{"$f":"'Category Guidance'!E17","v":5},{"$f":"'Category Guidance'!F17","v":"Severe"},{"$f":"'Category Guidance'!G17","v":"Severe degradation in technical performance; Cannot meet KPP or key technical/supportability threshold; will jeopardize program success"},{"$f":"'Category Guidance'!H17","v":"Cannot meet key program milestones. \nSlip > 12months"},null,{"$f":"'Category Guidance'!I17","v":"Exceeds APB threshold\n(> 10% of Budget)"}]
["No Action",{"$f":"rev_date","v":"2020-07-15"},"Initial Assessment","1 - Reference - DOD MRL Deskbook (pp 32) - http://www.dodmrl.com/MRL_Deskbook_2018.pdf"]
[null,null,null,"2 - Reference - Risk Management Guide for DOD Acquisition - Sixth Edition (Version 1.0)\nhttps://www.acq.osd.mil/damir/documents/DAES_2006_RISK_GUIDE.pdf"]
[]
[]
[]
[]
[]
[]
[{"$f":"distro_statement","v":"DISTRIBUTION STATEMENT: No Distribution Statement Determined. "}]

{"sheet":"Comp 5","index":10,"n_rows":43,"n_cols":21,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,0,43,9],[32,6,32,7],[32,8,32,9],[33,6,33,7],[33,8,33,9],[34,3,34,9],[35,3,36,9],[29,6,29,7],[29,8,29,9],[30,6,30,7],[30,8,30,9],[31,6,31,7],[31,8,31,9],[18,3,18,5],[18,7,19,7],[21,7,22,7],[26,3,26,9],[27,3,28,3],[27,4,28,4],[27,5,27,9],[28,6,28,7],[28,8,28,9],[13,17,14,17],[13,19,14,19],[13,20,14,20],[14,3,14,5],[15,3,15,7],[15,8,16,8],[15,9,16,9],[16,3,16,7],[13,16,14,16],[13,0,13,1],[13,3,13,5],[13,6,14,6],[13,7,14,7],[13,8,14,9],[12,3,12,5],[1,16,1,20],[2,0,2,2],[2,3,2,5],[2,8,3,8],[2,9,3,9],[2,11,9,14],[3,3,3,5],[4,3,4,5],[5,3,5,5],[6,3,6,5],[7,3,7,5],[8,3,8,5],[9,3,9,5],[10,3,10,5],[11,3,11,5],[0,0,0,1],[0,3,0,5],[0,6,0,9],[1,0,1,1],[1,3,1,5],[1,6,1,9]]}
["Component Name",null,"Component Supplier","OEM Point of Contact",null,null,"Component Engineer"]
["Name",null,"Supplier","POC",null,null,"Engineer",null,null,null,null,null,null,null,null,null,"This section is for charting and error checking - Do not alter"]
["Response to MRL Questions1",null,null,"Risk Statement",null,null,"Likelihood2","Consequence2","Impact\nScore","Weighted\nImpact\nScore",null,"Correcting Chart Data Labels in Excel:  After entering your L/C scores if the data labels appear as empty they must be reset in Excel.  Follow this procedure to make your data labels appear properly.\n1. Right Click on the data label box\n2. Select \"Format Data Label\"\n3. In the right hand drop down box select the far right \"Label Options\" Category\n4. Uncheck the box \"Value From Cells\"\n5. Re-Check the box \"Value From Cells\"\n6. Confirm selection area is =$A$5:$A$13\n7. Click OK\n8. Click \"Reset Label Text\"\n9. Close the EDIT drop down box",null,null,null,null,"Likelihood2","Consequence2",null,"Likelihood2","Consequence2"]
["Category/Question","y/n","Explanation for Response"," (derived from Explanation for Response)",null,null,"(of occurrence)","(to system)",null,null,null,null,null,null,null,null,"(of occurrence)","(to system)",null,"(of occurrence)","(to system)"]
["Materials","n",null,null,null,null,null,null,{"$f":"IF(AND(B5=\"y\",G5>0,G5<6,H5>0,H5<6),G5*H5,\"\")","v":""},{"$f":"IF(I5<>\"\",I5*9*('System Information'!B28/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B5=\"y\",G5>0,G5<6),G5,FALSE)","v":false},{"$f":"IF(AND(B5=\"y\",H5>0,H5<6),H5,FALSE)","v":false},null,{"$f":"IF(AND(Q5<>\"\",TRUE),Q5,0)","v":false},{"$f":"IF(R5<>\"\",R5,0)","v":false}]
["Cost","n",null,null,null,null,null,null,{"$f":"IF(AND(B6=\"y\",G6>0,G6<6,H6>0,H6<6),G6*H6,\"\")","v":""},{"$f":"IF(I6<>\"\",I6*9*('System Information'!B29/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,{"$f":"IF(AND(B6=\"y\",G6>0,G6<6),G6,FALSE)","v":false},{"$f":"IF(AND(B6=\"y\",H6>0,H6<6),H6,FALSE)","v":false},null,{"$f":"IF(Q6<>\"\",Q6,0)","v":false},false]
["Design","n",null,null,null,null,null,null,"",{"$f":"IF(I7<>\"\",I7*9*('System Information'!B30/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Manufacturing Process","n",null,null,null,null,null,null,"",{"$f":"IF(I8<>\"\",I8*9*('System Information'!B31/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Quality","n",null,null,null,null,null,null,"",{"$f":"IF(I9<>\"\",I9*9*('System Information'!B32/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Schedule","n",null,null,null,null,null,null,"",{"$f":"IF(I10<>\"\",I10*9*('System Information'!B33/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Facilities","n",null,null,null,null,null,null,"",{"$f":"IF(I11<>\"\",I11*9*('System Information'!B34/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Supply Chain Management","n",null,null,null,null,null,null,"",{"$f":"IF(I12<>\"\",I12*9*('System Information'!B35/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
["Industrial Base","n",null,null,null,null,null,null,"",{"$f":"IF(I13<>\"\",I13*9*('System Information'!B36/'System Information'!$B$37),\"\")","v":""},null,null,null,null,null,null,false,false,null,false,false]
[null,null,null,"Weighted Likelihood and Consequence:",null,null,{"$f":"IF(T14>0,T14,0)","v":0},{"$f":"IF(U14>0,U14,0)","v":0},null,null,null,null,null,null,null,null,null,null,null,{"$f":"IF(SUM(T5:T13)<>0,SUMSQ(T5:T13)/SUM(T5:T13),0)","v":0},{"$f":"IF(SUM(U5:U13)<>0,SUMSQ(U5:U13)/SUM(U5:U13),0)","v":0}]
[null,null,null,"(Used for Component/Supplier Risk Rating graphic)"]
[null,null,null,"Sum of Impact Scores:",null,null,null,null,{"$f":"IF(SUM(I5:I13)>0,SUM(I5:I13),0)","v":0},{"$f":"IF(SUM(J5:J13)>0,SUM(J5:J13),0)","v":0}]
[null,null,null,"(Used to rank potential resources required)  "]
[]
[null,null,null,{"$f":"'Category Guidance'!B2","v":"Category Guidance: Likelihood of Occurrence"},null,null,null,"Risk Rating"]
[null,null,null,{"$f":"'Category Guidance'!B3","v":"Level"},{"$f":"'Category Guidance'!C3","v":"Likelihood"},{"$f":"'Category Guidance'!D3","v":"Probability of Occurrence"}]
[null,null,null,{"$f":"'Category Guidance'!B4","v":1},{"$f":"'Category Guidance'!C4","v":"Not Likely"},{"$f":"'Category Guidance'!D4","v":"~10%"}]
[null,null,null,{"$f":"'Category Guidance'!B5","v":2},{"$f":"'Category Guidance'!C5","v":"Low Likelihood"},{"$f":"'Category Guidance'!D5","v":"~30%"},null,"Component Summary Sheet"]
[null,null,null,{"$f":"'Category Guidance'!B6","v":3},{"$f":"'Category Guidance'!C6","v":"Likely"},{"$f":"'Category Guidance'!D6","v":"~50%"}]
[null,null,null,{"$f":"'Category Guidance'!B7","v":4},{"$f":"'Category Guidance'!C7","v":"Highly Likely"},{"$f":"'Category Guidance'!D7","v":"~70%"},null,null,null,null,null,null,null,null,0]
[null,null,null,{"$f":"'Category Guidance'!B8","v":5},{"$f":"'Category Guidance'!C8","v":"Near Certainty"},{"$f":"'Category Guidance'!D8","v":"~90%"},null,"Hot Links "]
[]
[null,null,null,{"$f":"'Category Guidance'!E10","v":"Category Guidance: Consequence (System Impact)"}]
[null,null,null,{"$f":"'Category Guidance'!E11","v":"Level"},"Consequence",{"$f":"'Category Guidance'!G11","v":"System Impact"}]
[null,null,null,null,null,{"$f":"'Category Guidance'!G12","v":"Technical Performance"},{"$f":"'Category Guidance'!H12","v":"Schedule"},null,{"$f":"'Category Guidance'!I12","v":"Cost"}]
[null,null,null,{"$f":"'Category Guidance'!E13","v":1},{"$f":"'Category Guidance'!F13","v":"Minimal"},{"$f":"'Category Guidance'!G13","v":"Minimal or no consequence to technical performance"},{"$f":"'Category Guidance'!H13","v":"Minimal or no impact"},null,{"$f":"'Category Guidance'!I13","v":"Minimal or no impact"}]
[null,null,null,{"$f":"'Category Guidance'!E14","v":2},{"$f":"'Category Guidance'!F14","v":"Minor"},{"$f":"'Category Guidance'!G14","v":"Minor reduction in technical performance or supportability, can be tolerated with little or no impact on program"},{"$f":"'Category Guidance'!H14","v":"Able to meet key dates. \nSlip < 6 month(s)"},null,{"$f":"'Category Guidance'!I14","v":"Budget increase or unit production cost increases.\n(< 1% of Budget)"}]
[null,null,null,{"$f":"'Category Guidance'!E15","v":3},{"$f":"'Category Guidance'!F15","v":"Moderate"},{"$f":"'Category Guidance'!G15","v":"Moderate reduction in technical performance or supportability with limited impact on program objectives"},{"$f":"'Category Guidance'!H15","v":"Minor schedule slip. Able to meet key milestones with no schedule float.\nSlip < 6 month(s). Sub-system slip > 12 month(s) plus available float."},null,{"$f":"'Category Guidance'!I15","v":"Budget increase or unit production cost increases.\n(< 5% of Budget)"}]
[null,null,null,{"$f":"'Category Guidance'!E16","v":4},{"$f":"'Category Guidance'!F16","v":"Significant"},{"$f":"'Category Guidance'!G16","v":"Significant degradation in technical performance or major shortfall in supportability; may jeopardize program success"},{"$f":"'Category Guidance'!H16","v":"Program critical path affected.\nSlip < 12 months"},null,{"$f":"'Category Guidance'!I16","v":"Budget increase or unit production cost increases.\n(< 10% of Budget)"}]
["Action Taken with this Supplier","Date","Comments for Action Taken",{"$f":"'Category Guidance'!E17","v":5},{"$f":"'Category Guidance'!F17","v":"Severe"},{"$f":"'Category Guidance'!G17","v":"Severe degradation in technical performance; Cannot meet KPP or key technical/supportability threshold; will jeopardize program success"},{"$f":"'Category Guidance'!H17","v":"Cannot meet key program milestones. \nSlip > 12months"},null,{"$f":"'Category Guidance'!I17","v":"Exceeds APB threshold\n(> 10% of Budget)"}]
["No Action",{"$f":"rev_date","v":"2020-07-15"},"Initial Assessment","1 - Reference - DOD MRL Deskbook (pp 32) - http://www.dodmrl.com/MRL_Deskbook_2018.pdf"]
[null,null,null,"2 - Reference - Risk Management Guide for DOD Acquisition - Sixth Edition (Version 1.0)\nhttps://www.acq.osd.mil/damir/documents/DAES_2006_RISK_GUIDE.pdf"]
[]
[]
[]
[]
[]
[]
[{"$f":"distro_statement","v":"DISTRIBUTION STATEMENT: No Distribution Statement Determined. "}]

{"sheet":"Category Guidance","index":11,"n_rows":17,"n_cols":9,"rows_kept":17,"cut":false,"hidden":false,"merged":[[9,4,9,8],[10,4,11,4],[10,5,11,5],[10,6,10,8],[1,1,1,3]]}
[]
[null,"Category Guidance: Likelihood of Occurrence"]
[null,"Level","Likelihood","Probability of Occurrence"]
[null,1,"Not Likely","~10%"]
[null,2,"Low Likelihood","~30%"]
[null,3,"Likely","~50%"]
[null,4,"Highly Likely","~70%"]
[null,5,"Near Certainty","~90%"]
[]
[null,null,null,null,"Category Guidance: Consequence (System Impact)"]
[null,null,null,null,"Level","Consequence","System Impact"]
[null,null,null,null,null,null,"Technical Performance","Schedule","Cost"]
[null,null,null,null,1,"Minimal","Minimal or no consequence to technical performance","Minimal or no impact","Minimal or no impact"]
[null,null,null,null,2,"Minor","Minor reduction in technical performance or supportability, can be tolerated with little or no impact on program",{"$f":"\"Able to meet key dates. \nSlip < \"&'System Information'!B40&\" month(s)\"","v":"Able to meet key dates. \nSlip < 6 month(s)"},"Budget increase or unit production cost increases.\n(< 1% of Budget)"]
[null,null,null,null,3,"Moderate","Moderate reduction in technical performance or supportability with limited impact on program objectives",{"$f":"\"Minor schedule slip. Able to meet key milestones with no schedule float.\nSlip < \"&'System Information'!B40&\" month(s). Sub-system slip > \"&'System Information'!B41&\" month(s) plus available float.\"","v":"Minor schedule slip. Able to meet key milestones with no schedule float.\nSlip < 6 month(s). Sub-system slip > 12 month(s) plus available float."},"Budget increase or unit production cost increases.\n(< 5% of Budget)"]
[null,null,null,null,4,"Significant","Significant degradation in technical performance or major shortfall in supportability; may jeopardize program success",{"$f":"\"Program critical path affected.\nSlip < \"&'System Information'!B42&\" months\"","v":"Program critical path affected.\nSlip < 12 months"},"Budget increase or unit production cost increases.\n(< 10% of Budget)"]
[null,null,null,null,5,"Severe","Severe degradation in technical performance; Cannot meet KPP or key technical/supportability threshold; will jeopardize program success",{"$f":"\"Cannot meet key program milestones. \nSlip > \"&'System Information'!B43&\"months\"","v":"Cannot meet key program milestones. \nSlip > 12months"},"Exceeds APB threshold\n(> 10% of Budget)"]